-
Show the task name of predecessor
How can I get the task name to show up next to the predecessor in the sheet rather than clicking on the edit key? When creating new sheets based on existing projects, I spend a lot of time tracking down what tasks are being rreferenced. Thanks! -Shelly
-
Auto changing numbers
Hello, I'm having a strange issue, where I enter a lengthy number and then when I click out of the cell where I entered it, Smartsheet has changed it to a number immediately above or below the number I entered. When I double click in the cell, it shows me the original number I entered, then changes it again when I click…
-
Formula help
I have a request for time off form, when a request is submitted the person is notified that if they do not receive a response within 5 business days they can consider this approved, however I would like to create a formula that is based off the auto created date so if Approved column (where supervisor notes if it is…
-
Comments change
If you have multiple users, can they see if there are any changes to the comments? new repply, new comment added? Also If there are any changes done, like new tasks, new status, is it possible for other users to quicly indenfy those changes? thank you
-
Replace a formula with its result
Hello everyone, i'm trying using this option in smartsheet to ignore the formula in some cell. With excel i can use F2 then F9. Anyone know if smartsheet have this option? Thank you, Daniel
-
How to calculate schedule % updates in Smartsheet
Hi, I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration. i added a column with percentage updates as per schedule however, these percentages do not roll up to the…
-
To set RYG using a formula that considers Todays date and Completion %
I would like to set the risk RYG status column colour based on set conditions. IF % complete = 0 And 'start' is todays date to show Risk IF % complete = between 90 & 100 to show Green somethign like this but it doesn't work =IF(AND([% Complete]row# = "0", [Start]165="TODAY", "Red")) Any ideas?
-
Sheet showing blank
Hi All, I wonder if someone can assist me. I created a sheet by importing an Excel workbook. When I open the sheet via SS, it shows blank. But when I click on the link as in the email I send for the Invitation to VIew to users it opens up the sheet and all the data is there. I am concerned I know to click on the link but…
-
API: Copying only specific columns within a row
I want to copy a row from Sheet A > Sheet B. Sheet A contains several columns that Sheet B does not. Currently, moving the row results in Smartsheet automatically creating the ommited columns in Sheet B and dumping them at the end. Is it possible using the API, to select only the columns I want to move? Or to somehow…
-
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.