Login Page - Create Account

Support Board


Date/Time: Sat, 05 Jul 2025 07:43:21 +0000



Post From: COULD USE SOME CODING HELP FROM USERS/SUPPORT

[2019-09-09 20:16:20]
ForgivingComputers.com - Posts: 1076
You can simplify it a couple of ways:

1. Use AA3 instead of ID1.SG1@3, AB3 for ID1.SG2, etc. You can reduce the number of formula columns to get them in the K-Z range, eliminating a few more characters.

2. Sierra Spreadsheets also support the following syntax: =(M3>N3>O3), which will be a 1 only if M3 > N3 and N3 > O3
Date Time Of Last Edit: 2019-09-09 20:18:20