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,
I'm new to Smartsheet and I'm having some issues with one of my formulas. I want to get a count of everything where the Status = Completed and then the following:
You will need to use a helper column to establish how the dates compare.
You can then use a COUNTIFS function to include the two sets of range/criteria.
thank you!
Happy to help!
Hi everyone! I have a list of report dates that I want to be notified on, but am having trouble getting this set up. My thought process was to create a column with =TODAY() in the first cell, and then set up automations to be alerted when "Today" equals the "Report Date". My issue is that two are different formats. The…
Currently below is what Smartsheet allows for Group management. In our organization, this is very restrictive as it only allows 3 people to manage groups that required a lot of maintenance. Allows Group Admins this ability would make it much more flexible for large organizations who have multiple individuals with the…
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…
