Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi all,
2 in May and 2 in June right? 4 total
Why does the 2nd row show 3?
Darrell
It looks like it is including the start date itself even though it is a weekend since it is a start date and not just tucked in the middle.
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
Looking to calculate the % of empty cells in a sheet for all rows that have data, with the intention of excluding any rows beyond my last row. I'd like to use this to motivate relevant stakeholders to completely populate the columns. Thank you.
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
