-
Automatic creation of sheets
Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker that I've setup as a template. And can those trackers be automatically saved in another…
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
-
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…