Under Report > Send as an Attachment it is possible to schedule a recurring email. It is also possible to edit the recurrence deliver options but not to edit the email itself. You have to delete the r…
Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a ri…
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Sma…
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple col…
Hi, all. As the attached shows, I have a rule to turn the whole row a color if the Task Name contains "S18 D1". But, only one row is colored? Am I doing something wrong? Thanks!
Hello, Using drop down choices in columns, is there a way to take a column with a certain data value, & then in the following column, only certain choices appear in the drop down choices found there, …
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar col…
Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Cat…
Hi all! I'm creating an intake form to help business leaders prioritize and force rank of dependencies. Example: Main project: Develop a recyclable lid for water bottles Owner: Barney Rubble I'd like …
Hi, I am using an "Issued" date column as a trigger to send approval requests. I am trying to capture the number of days since the request was issued in the "Age" column, where I have this formula: =N…
