Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 07:25:25 +0000



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

[2019-09-09 20:16:20]
bradh - Posts: 854
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