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…
It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…
Hi all, Our org has dozens of workspaces and while we have moved more toward group-based permissions recently, I still have some legacy workspaces that were configured with dozens of individual user a…