Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
Can you archive some of that data by copying it to a new sheet? Maybe by year?
Unfortunately no. I've already split the data into 4 tables. The issue is the number of columns and rows I need totals on.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have two Smartsheet's. The First Smartsheet contains all the original data. The Second Smartsheet will contain unique values from one of the columns (the column with a 1 in the IDUn... column). In the Second Smartsheet, I need formulas in the individual column row fields to look up and match the value in the IDUn...…
Hi, I am trying to calculate duration and I have tried every formula I can google leaving me with unparseable or incorrect argument set... the fields I am trying to use in my metric sheet are "Actual Start Date" and then TODAYS date. I currently have several variations of this =IF(TODAY() - [Actual Start Date]@row)) or…
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
©2024. All Rights Reserved Smartsheet Inc.