I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends…
Hi community, Our organization just purchased Smartsheet Enterprise License - and is looking for consultants to build the solutions which require API integration. We have contacted with Smartsheet int…
Hello, Is there a reason why my workflow will not save when I select to run it "Hourly"? The only option that works is "When Triggered". There is nothing that is telling my I need to add information (…
2 issues How to cross-link dependencies between separate project management sheets How to see these cross-link dependencies in a summary sheet I looked into these 3 sites for cross-linking dependencie…
Hi all, I am needing to present a few of my dashboards, in real-time, on a 24 hour cycle. I will be presenting about four individual dashboards but I am running into a bit of a snag. I tried using Rev…
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the shee…
Hi, I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change. For example: If status change to "option 1" change this date field …
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of gettin…
I have 3 fields. 2 fields are checkboxes and 1 is text. Active (checkbox) Not Active (checkbox) Complete (Yes/No) I want to write a nested IF statement that if either are checked it provides a Yes / N…