-
IF((CONTAINS)) function
I'm trying to verify that the emails in a column have the correct spelling. I'm using an IF((CONTAINS)) function, but it's not working =IF(CONTAINS("@kintegra .org", EMAIL@row ), "", "Check eMail")
-
Health Ripple Effect Formula
On my project plans, I use a Red/Yellow/Green/Gray column called [Health], and I also use the stock [Predecessors] column. I'm trying to come up with a column formula so that if I change the [Health] value on a given row, it will update the [Health]@row value of every row downstream that directly or indirectly uses the…
-
Printing a Gantt Sheet
Hello I would like to suggest if there is a way to have the columns print the same in a gantt sheet as a grid. For example, when I change the sizes (smaller or larger) of some of the columns and then export the Gantt sheet to print- it changes the sizing for printing. I look forward to seeing this change. Thank you!
-
Show all files that are pulling information from a file
We want the ability to see (on any file type) what other files are pulling information from the current file we are on to understand the dependency between sheets/dashboards/reports/etc.
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Make sheet data available to external 'viewers' but limited to only their data
Good morning Smartsheet community. I have been using Smartsheet in my job as the office manager for a small business. I'm self taught and have managed to get some workflow and automations working through trial and error. However, I am stumped on the next project that I'm trying to figure out how to best handle inside…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…
-
SS giving message "Please log out and log back into the app before continuing" and not able to acces
All smartsheets from a workspace is giving the message "Please log out and log back into the app before continuing" when trying to access. Team logged out, cleared cache, used incognito browser and they are still getting this message. An entire team is impacted since yesterday. A case was opened on support however no one…
-
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
-
Move the Deleted function to another section
Please move the Delete function away from the Edit function for a row in a worksheet. THIS CAUSES A LOT OF ISSUES JUST BY BEING NEAR EACH OTHER!!! Locking rows isn't an option, unless you can tell me if I can lock only certain columns.