I want to calculate the average NETDAYS between these two columns as a field in my sheet summary. How can I accomplish this?
I believe you'd have to have a third column with =Netdays([start date], [end date]) as a column formula, and just take an average of that.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
©2024. All Rights Reserved Smartsheet Inc.