-
COUNTIFS Cross Sheet Error
I have written these hundreds of times but for some reason I am missing something with this one. Simple, trying to count "Health" based on what we call Seq, in this case TSK. Building a metrics sheet for Dashboards. This formula is producing a Unparsable error and I cannot find the error. =COUNTIFS({DSV 3PL Schedule Range…
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
I just shipped v1.0 of an open-source AI agent that lets you talk to your sheets — 73 tools, 80 formulas, BYOT, MIT licence
Hi everyone 👋 I've been a Smartsheet power user since 2013 and last month I finally caved on a side-project I'd been daydreaming about for years: stop clicking, start talking to my sheets. Today I'm releasing v1.0.0 of Talk to Your Smartsheet — a community-built, MIT-licensed AI agent that speaks the Smartsheet REST API…
-
Notifications in advance of dates
I would like to be able to program SmartSheets to send a notification of upcoming dates (i.e. 90 days before the date shown in SmartSheets) to specific people. I have played around with the notifications option and can't seem to get it fine tuned. It notifies of all future dates, not just those that fall within 90 days.
-
Multiple Projects into a high level Programme / Portfolio Project
Hi Clever Community, Sorry to ask this question as I believe I've seen the answer but that was 4-5 years ago and I cannot find the article now. So I have 4 projects, each with a suite of smartsheets (all from a template) including risks, actions, milestones and timeline. So each of the 4 have the same fields and layout…
-
renewed subscription and all files are read only: how to fix this?
renewed subscription and all files are read only: how to fix this?
-
How can I make a timeline widget respect the structure and order of my plan instead of sorting items alphabetically?
Hello, How can I make a timeline widget respect the structure and order of my plan instead of sorting items alphabetically? I’ve already tried using filters, but when I apply them, the items are still automatically sorted alphabetically or by date. Thank you in advance.
-
Hey guys, is there a way in Smartsheet to return the day of the week based on a date entered?
Example: Cell 1 contains the date as "8 April 2022". Cell two returns the text "Friday".
-
Actual FOLDER permissions in a workspace
We have a workspace for our Director and his direct reports. They each need to have their own folder within the workspace where only they see the information. I know we have permissions for specific sheets but they need access to the workspace and when we do that they then have access to all the other folders and sheets…
-
Form Submission Error Message
Hi Everyone, I have a form that I created which has been working just fine until I had a user notify me that they were getting this error message: I had them refresh and try again but he kept receiving this message. I then also submitted a Test form and that worked fine (although took a while to refresh on the sheet). Does…