-
Send Update Request
Hello All I want to share an exciting SS discovery! I am currently doing the Smartsheet Project Management course. The send Update Request function will truly transform my work life. This option does not require the person being requested information to log into smartsheet to answer the specific questions I require…
-
RYG Formula...
Looking for assistance. I am looking for a formula that adds the total number of individually RYG in a column that automatically populates a separate cell in a separate column. Any guidance would be appreciated. Thanks. - Erik
-
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
-
Filtering Alerts
We use a sheet to keep track of documents in the review process. Is there a way to set a filtered alert so someone identified as a document reviewer gets notified when they have been added as a reviewer? Would also like to know ifthere is a way to filter an alert so that a user who uploaded a document for review only gets…
-
Calculate due date based on start date + either 1 or 5 days
I need to calculate a investigation date which would be 5 days, unless the "foodborne Illness" cell is checked, inwhich case the investigation date is 1 day after the complaint date. This is for a complaint log I am putting together. I want to auto populate the deadline for the inspector to initiate the investigation. I…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
Promoting Smartsheet
How much does anyone else promote this program. Have you heard the words"are these guys paying you". I just completed a mastermind group and it was a dominate topic for me in addressing how business owners can advance their company. I am wondering what is the level that all of us on here feel and promote about this…
-
combining formula to round a sum
I'd like to know if I can combine the two following formulas in some way so that I only need one column: In the first below, I'm calculating the average number of minutes an editor spends on each page of a document. But, because I don't want to report the number with such precision, I have a second column with a formula to…
-
How to send all attachment files via an email
Some managers don't want to learn a new tool or even follow a link. I'd like to schedule a weekly status report that just sends all attachments (only the latest version of each attachment) to email recipients.
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…