Currently, it is possible to be logged in Smartsheet and Dynamic View under two different accounts, simultaneously, on the same machine. Unless a user explicitly logs out of Dynamic View or clears the…
Currently, my team has several different forms that we use to track process KPIs, or to populate other files. This means we have to post or carry around a handful of QR codes linking to those various …
Dear SmartSheet Community, I need your help. I need help in writing a formula that will track compliance for different areas based on expiration dates. If dates are active and will not expire in the n…
I've been trying to write a formula that will "Check a checkbox (in sheet A) IF [name] cell (in sheet A) is found in {name} column (in sheet B), AND the box in [checkbox] column (in sheet B) is checke…
Hi All, I'd like to add a column that reflects how many days my project plan is ahead/behind schedule. I asked this question last year, but couldn't find it anywhere. I have a Planned Finish and a Fin…
Hello, Any suggestions on the best way to calculate the average days if the item type is equal to quarterly? I have a drop-down menu that categorizes the activities based on frequency, and another col…
Help please. I have no idea how to combine formulas. I just want to round up this 6.83 to 7. What am I doing wrong? I don't want to use the "move over 2 decimal places" in the menu bar above because I…
Have an issue I cannot seem to resolve to automate a checkbox. I have a "Content" sheet that is data coming from a source outside Smartsheet. Relevant columns look like this: I have a separate sheet (…
Hello! I'm struggling to complete this formula without receiving errors. I am currently attempting to create formula in a project tracking sheet to return colored symbols (R,G,Y,G) into a "Project Hea…
I am trying to determine average from a referenced table with 2 different filters (i.e. Column A = YES AND Column B - X-Small). I can figure out how to AVERAGEIF to filter based on one column but not …
