-
This formula is working for other number ranges but not this one
Hello, Trying to do a count and this formula is working for all other number ranges, except for this one. Any ideas? Formula is this: =COUNTIFS([Risk Issue Factor Priority]:[Risk Issue Factor Priority], ">0", [Risk Issue Factor Priority]:[Risk Issue Factor Priority], "<7", Status:Status, "<>Complete", Status:Status,…
-
Tracking completion times
Hi everyone, I have a Smartsheet that has requests for updates that go to 10 different departments. We are asking that each step in the process be completed within 24 hours. I would like to track the time it takes to complete each step. Here's the complication, there are requests that go out to say 3 different departments…
-
Merged: If Contains formula
This discussion has been merged.
-
Adding a PDF
I have a fillable PDF and want it automatically emailed when certain criteria are met in the sheet. Once emailed, recipients should be able to complete and reattach the PDF to the document. Is this possible? Our account includes all premium options, but I can't find how to do this.
-
Copy Row Workflow Delaying 16 Hours
I have a simple "copy row" automation that is delaying execution. Most recently, it delayed 16 hours - it was supposed to complete one afternoon, but did not until the following morning. It is working out of a very busy project tracker, so I assume there are too many workflows happening at the same time. How am I able to…
-
[GIVEAWAY] Win a Smartsheet Certification
Hello Community, The new Smartsheet Professional Certification is live! To celebrate your dedication to leveling up your skills, we're giving away one Learning & Certification Pass to help a lucky member get certified for free! Participating is very easy, just tell us in the comments below: What’s ONE reason getting…
-
Best Practices for overall schedule deviation
I'm trying to find the best way to show the overall difference between the date the case was Started and Finished. ideally it would organize all opened and closed cases showing an overall schedule/performance
-
User Level Admin
Proposal: Creation of a Dedicated User Administration Role in Smartsheet Objective: Introduce a new Administration Role within Smartsheet designed to assist with user management tasks while maintaining strict security boundaries. Scope of Responsibilities: Manage provisional users and oversee user licensing. Perform…
-
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.
-
Contacts
I created a new project in my PMO, when I tried to pick a contact there were very few listed 7 versus the 165 people in my org. I checked My Contacts and all of the contacts were listed. Do I need to link that somehow to my sheet? How would I do that? Second question, what is the best strategy to keep My Contacts updated…