-
Dashboards for comparisons from year to year
I am trying to write a formula that will compare two sheets of data, one is last year and one the current year. I want to know what items where received last year on this date and it run/update daily. If that makes sense.
-
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
-
January Question of the Month - Join the conversation and receive a badge
Happy 2026, Community. I am so happy to welcome a brand-new year with all of you. I hope you’ve had a wonderful holiday season and are feeling inspired to make 2026 one for the books! We closed 2025 with your creative holiday ideas, and honestly, I wish I could add them all to the calendar. Based on your responses, I think…
-
Where did support go?
So I have no idea what happened but having a business license apparently doesn't allow you to get any support from Smartsheet now? I can only use their broken AI Agent to create tickets that go nowhere? I opened a ticket 3 weeks ago that nobody has looked at or contacted me about and the AI will only allow me to open…
-
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
-
Audit Log of Automated Messages / Notifications
We're looking to implement automated notifications via smartsheet to a list of our business partners. Our compliance team would like to be able to keep a log of the recipients to which these notifications are sent, which to my understanding is not available currently.
-
new GRANDPARENT() function
I would greatly appreciate a Grandparent function, especially since PARENT(PARENT()) throws an error. I know we have ANCESTORS(), but that gives you the number of ancestors and I need the specific ancestor value. Ideally, the GRANDPARENT() function would be GRANDPARENT( [reference], [# of generations back] ), that way it…
-
Can you make a dropdown option dependent upon another drop down? Parent / child
Hi, I am trying to setup 2 drop downs in a grid sheet. The user will select from the first dropdown (parent) A, B, C and based upon what they select i only want to show the corresponding options in the second dropdown (child). So for A show 1, 2, or 3 For B show 4, 5, or 6 For C show 7, 8, or 9 . Using a form is not an…
-
Backing Up Smartsheet FORMS & Restoring a Deleted Form
There needs to be a way to back-up created Forms and allow them to be restored. This has caused a huge disaster when someone on my team just accidently deleted a form last week.
-
Dancing With The Stars
Hey family! I have a column with the Stars symbol. I'm using it to rank 1 to 5. While its pretty, I can't seem to quantify them. For example 5 stars = 90%, 4 stars = 70%, etc. this formula doesn't seem to work: =IFERROR(IF(VALUE(Probability@row ) = 5, 0.9, IF(VALUE(Probability@row ) = 4, 0.7, IF(VALUE(Probability@row ) =…