-
Conditional formatting to specific cells only
Is there a way I can apply conditional formatting to only specific calls rather than an entire row or column? In excel I have an area which is red if a job isn't making a profit and green if it is. I want to keep the white bits white though!
-
Update Parent Row based on Child status
Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") > 0, "Open", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(),…
-
New records not being auto added in reference sheet
Hi all. Fairly new user here. I have a Smartsheet form that we have users fill out and the results go to a "smart" sheet. Call it Sheet A. We then have another sheet, Sheet B, that references certain columns in Sheet A. I was under the impression that any new records submitted into Sheet A would automatically move over…
-
How do I trigger an automation on a sheet that is not open?
The problem: The "on change" automation does not trigger despite the flag changing - this is happening on a sheet that is not running. The situation: I have 2 sheets. Sheet 1, The Active List, has a list of active employees. Sheet 2, The Remove List, is populated via data uploader (replace). It contains employees who leave…
-
How to block the date in a sheet to the creation day only?
Hello everyone! I hope this question has not already been asked, I did not find it on the forum. I have a sheet linked to a form that generates data for me. The form is used by employees and in my sheet the date of creation of a new entry is automatically generated. My problem is that when I "play" in the lines of the…
-
Report Gantt formatting is not showing in the dashboard
Hey All, First time post. I looked through some keyword searches for my problem, but didn't find this specific issue. I am rolling up all my projects into a high level filtered report and formatting the Gantt for my directors using the following settings: Everything looks great: However, when I pull this specific report to…
-
formula - Time
I have a sheet with an auto Created date & time column AND a modified date & time column. Is there a way to create a formula column that will show Modified Date Time (minus) Create Date Time?
-
How to check if a column has a value on a certain row with matching cell?
Hi, I have two sheets, Allocations & Installations. Once an Allocation is approved, the row gets copied to Installation. When the Installation is completed it is marked as such on the same sheet. I would like to automatically have it marked on Allocation as well. They share a [Shop ID] cell. So i need to check from…
-
Locking Sort?
Hi Folks, I have a project sheet shared amongst my team where various "editors" are constantly updating statuses, priorities, etc. I have a sort set to first show project status, then priority, but am finding that all of my "editors" can update the sort at any point. It's throwing all the data out of wack. Anything I can…
-
Webhooks vs Built-In Automation
I know that automated workflows in smartsheet won't take place if the trigger is a change on a cell link. Will the same happen in the case of when a webhook is triggered? Will a webhook send if the trigger is a cell linked column?