-
Smartsheet formulas with multiple columns
We're using Smartsheet for some change management, and I'm new to both Smartsheet and spreadsheet formulas. What I’d like to do is have a formula looks at a column that indicates the type of change (Major, Minor, Emergency, etc.) and then looks at a number of check boxes and adds an approval in a separate column. So, for…
-
Conditional Formatting: "Today is in-between Start Date and End Date"?
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached image - bright green is a "today" task, and the woodland green is default). How can I extend my conditional formatting to…
-
If then statement for Risk Management Matrix
Hi Folks - I'd like to feedback to write a formula that evaluates the following: =IF(Cell A1 "Acceptable" then??? Acceptable Tolerable Undesirable Intolerable "Then"... the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2,…
-
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
-
Smartsheet Merge issue when using Combine-into-one-file option
When I attempt to use the combine into one file option, such as when I'm using a 1-page Google document template to print five (5) rows into 5 pages, the combined file output exhibits the following errors: 1. Contents in the header are not displayed in the combined file per page; when I use the merge print on single pages,…
-
Cannot Login from China
Hi, My colleagues from China cannot login to SmartSheet start from yesterday afternoon. Before it was OK. He tried from different computers, also tried clear his borowser's history and cookies, but still failed. Then we asked friends from other cities in China tried to logon, they all have similar problems. They can open…
-
Screen Snipping Tool
Is there any way to screen snip and have the snapshot saved as an attachment? The only way currently appears to be screen snipping and save into word and then attach or save as image and then attach that
-
Indivisual Row Sharing with Different Users is it Possible...?
Can we share indivisual rows with different users to update sheets. we dont want to use any web forms we need to share sheet, but different rows to different users.
-
Status of Child rows
Hi I am trying to create a Project Schedule with Budget and Variance and include an overall status using the status of the child rows. I have 1 line that is the overall project and then 4 phase lines, with around 20 tasks underneath each phase line. I want the phase lines to give an overall status of the child task rows…
-
Collaboration between two client who both use SmartSheet
Looking for suggestions / best practices to make the most of SmartSheet with an important client who is ALSO a huge SmartSheet user. First step they requested is a simple file repository - will grow from there...
