-
Re: Are you going to add the save feature for forms that are not completed in one session? Save as draft
Not exactly the same, but you can create an update request based off a checkbox, then label the checkbox "I'm not finished, i'd like to make changes later" or something to that effect.2 · -
Re: #UNPARSEABLE When Creating =AVERAGE(COLLECT Formula
=AVERAGE(COLLECT({MonthsEmp}, {TermYear}, "CURRENTLY EMPLOYED", {DivAtTerm}, "ADMIN")) changes to =JOIN(COLLECT({MonthsEmp}, {TermYear}, "CURRENTLY EMPLOYED", {DivAtTerm…1 · -
Re: #UNPARSEABLE When Creating =AVERAGE(COLLECT Formula
Try changing the average to a join with a comma as a delimiter and see what is being pushed to the average from the collect for the second one its the same formula with a small adjustment. replace &q…1 · -
Re: Calculating Data from Unique Values Only?
Use a helper column to identify the columns you want to count, then use a sumif based on the helper column. Instead of distinct, use a countif with an absolute reference to grab the desired submissio…1 · -
Re: Importing a 10,000 lines x 60 columns sheet
Try importing 2 separate smartsheets with 5k rows each. Then you can use a move workflow with a checkbox column to merge them together.1 ·