-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Scheduled updates
Is there a plan to allow you to delete transferred owner ship tasks under the edit function? Scenario - I create 10 tasks to "owner 1" - Owner 1 requests for 2 tasks to be transferred to an new owner - I have to delete all scheduled updates for owner 1 - re-schedule, then build a new schedule for "owner 2" Under the edit…
-
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…