Discussion List
Sync Smartsheet Calendar with Outlook Calendar
Hi, I am looking for the latest and greatest training information regarding how to sync your SmartSheet calendar with your outlook calendar. If anyone can help, please let me know. Thank you, Allison Bishop
Formula showing past due amount when no items meet criteria
Hi!
Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
Comment Sorting
It would be nice to sort comments. For example in google, you can select only comments "For You". I would also like to "resolve" comments like in google so they are hidden once not needed. sorting by active vs. resolved would be nice too. or sorting by another user. Lots could be done here.
Copying Workflows between Sheets
In my operational work I use Sheets as Action Trackers for all the countries we are implementing my project. When I was tracking about 5 countries I got the idea to create workflow that if any task is assigned to me the line is automatically copied to another sheet that is actually my Kanban Board so in one place I can see…
Self Pace Formula session not working entering information
I have completed 4 of the self paced lesson on Smartsheet core. The 4th Lesson, Formulas, the system will not recognize my clicking, entering the required information. I use Chrome - cleared browser cache etc. Tried Firefox. My default computer is a Mac - also tried it on a PC...any ideas?
Count of all rows that do NOT have a completed status
I'm trying to get a count of all cases that are not complete (aka open), to use on a dashboard metric widget. Eventually I'd probably like to be able to have a metric widget showing the count of cases that are in each status EXCEPT complete. I've dug around on the communities and I can't seem to get it to work. This is…
Bridge Workflow Error Notification
I'd like the option to detect errors and trigger a notification to myself when a Bridge Workflow stops. This would be particularly useful when running a child workflow as the entire parent and all subsequent children workflows will stop running if an error occurs. It would be nice to know that I need to retrigger my parent…
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…