Sign in to join the conversation:
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?
If you only have the criteria of excluding "INDEX DATA", you can use the AVERAGEIF function.
=AVERAGEIF([Average Column]:[Average Column], @cell <> "INDEX DATA", [Average Column]:[Average Column])
Paul thank you for trying to help but that formula didn't work. I provided a screen shot of the column I am trying to average, W/O Time Lapse column.
I am unable to see any screenshots. Could you try re-posting it?
figured it out thank you!
Hello, I deal with a lot of batch/lot numbers that are automatically generated and start with leading zeros (e.g. 000012345). I'm trying to create a column simply to count the instances of a lot number within the column in order to quickly identify duplicates. The formula I have is =COUNTIF([Lot Number]:[Lot Number],[Lot…
I have a formula in a Smartsheet that will show the last step date completed in one column and then another formula that will show the next step to be completed. The issue I have run into is that if 2 steps are completed the same day, SS is only picking up on the first one and showing the 2nd one as the next step to be…
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
