-
IFERROR Formula
Hi All, Hope you're keeping well. I've recently started playing with IFERROR's and updating some existing sheets. I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.…
-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…
-
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…
