-
Re: Identifying a ticked checkbox in an =IF formula
1 and 0 if([This column]1=1,"true","false") will post true when the checkbox is checked. if([This Column]1=0,"true","false") will post true when the checkbox i…3 · -
Re: SUMIF and INDEX/MATCH in one formula
With other sheet references you don't use a colon. =SUM(COLLECT({ISP Order Sheet Range 1}, {ISP Order Sheet Range 2},@cell = Description@row}))1 · -
Re: Can an Excel form be used to populate a sheet?
I've managed this in VBA before. If you are interested I can help you put your information from excel to smartsheet. The general concept behind it is On submission you save each item in vba to a vari…7 · -
Re: Nominate Peak Humans & get a badge!
@Genevieve P. @Paul Newcome Both are methodical in approaching problems, consistent, and also I have watched them learn on one topic and immediately turn around and apply what they learned to other v…10 · -
Re: Why is DATEONLY() returning the wrong date?
My understanding of this is they are on pacific time as smartsheet is based out of seattle. So the datetime in the background is always going to be pacific time, and is converted to local time for th…7 ·