As our company's Smartsheet Admin, it's a bit of a struggle that there is no granularity between Editor and Admin within a sheet or workspace. Many of my users need to be able to do things like create…
I've set up a connector to track certain Jira tickets over in Smartsheet as well. Even though I used the Contact List type of column, the Assignees are not coming over to the Smartsheet through the co…
Ok, I know it's something small but I can't see it. Can someone please tell me what is wrong with my formula? I'm getting an Incorrect Argument Set =COUNTIFS(Urgency:Urgency, "1 - URGENT Need attentio…
Starting next week, I will be moving from one Smartsheet Account to another and it will be a hard cut off, I won't have access to both at the same time. Is there a way to transfer my Smartsheet Commun…
Hi all! I have a form that is suddenly not pushing the submission response to the tracker. It was working fine and then 10 minutes later it just stopped sending the information to the sheet. I've trie…
I keep getting the above error code for one of my meshes. I have already tried recreating the Data Mesh as well as going Incognito to avoid any caching issues. I cannot figure out what seems to be mis…
So, I am working with this formula, which works great, but I need to throw in a CONTAINS aspect into it...and what I am trying is not working. Current formula (that works): =AVERAGEIF([Project/Task/Is…
My team currently uses a vertically formatted sheet as a Project Management Schedule. Using Gantt charts, we track tasks and milestones in rows vs columns. Of course, now, I'm being asked to report on…
Here is my formula: =SUMIF({Shell Projects - High Level Tracker CP}, Wholesaler@row, {Shell Projects - High Level Tracker Owner}) I'm trying to say, if the "Owner" on another sheet equals the Wholesal…
Is it possible to rotate a text widget on a dashboard so that it can look like this? I don't see any obvious ways but I'm wondering if anyone has any tricks up their sleeves.