Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone. As conditions like change the color of a cell …
Good Afternoon, I'm trying to add columns that only contain text. I have a column where the users insert "issues" that they have with that particular line item. At the bottom of the sheet, I need to h…
Hi all, I am unsuccessfully trying to create a formula for the following RYGG column: Column [Project at Risk] with the RYGG: * If [PROJECT START] (date) is more then a day over I want the [PROJECT@RI…
I have a parent row where its high level description of task, The clhildrens rows are action items and next steps that have unique formatting. I would like collaborators with minimal SS experience to …
This might be incredibly simple but I can't seem to find it already answered! Sometimes when I set a Finish to Start predecessor, the auto-filled "Start Date" is the same date as the predecessor row i…
Hit a brick wall, but I'll try to explain as best I can. Cell1 has a formula for a NUMERICAL sum for a row across [Column A] + [Column B] Cell2 has a formula to return TEXT based on value of a single …
I've got an auto-number column in one of my sheets, which has data from an excel sheet that I used prior to smartsheet. Most of the numbers in the auto-number column were from historical data and need…
I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats w…
Hi I would like to be able to create a column drop down with our 8 of our staff names and be able to select multiple drivers in one column is this possible how do I do this? For example David, Richard…
I'm trying to add a user's email as a secondary email, but it's telling me the address is already in use. I can't however, find the other address as a user account. is there a way of finding out if it…
Hi Smartsheet superusers! Ok, so I used Smartsheet with a previous employer for a few years and it's been about two years since I was really working in the system. My potential new employer uses it an…
I have data on a "copy of construction checklist" that has been shared to me. I am an admin to the shared copy of construction checklist. If the owner of the sheet, cycles data off the sheet due to co…