-
Can a Form field be auto populated?
I have a form that all Project Managers complete each week. When they open the form I would like to auto populate some of the Form fields with data from various sheets. Is there a formula that I can add to the form that will retrieve data from a cell elsewhere in Smartsheet?
-
Question regarding automatic date for parent row if all children have a date
This is what I have so far, but it populates the date if one out of (how many children) is filled in. IF(COUNTIFS(CHILDREN(), ISDATE(@cell)) > 0, MIN(CHILDREN()), "") I would like it to return the last date only if all the children have a date in their respective row. Thank you
-
Need help with the formula to update status based on changes to a field
Hi, I need help with a formula to automatically update status based on changes to multiple fields for example- I have =IF([Assigned To]@row <> "", "In Progress") to change status to In Progress when an input(name) is entered in the "assigned to" field Now, I want the status to change to "In Review" when a name is entered…
-
RYGB Balls Formula
I'm using Smarthseet to manage a project work plan. I have used the formula below to automate RYGB balls. =IF(AND([Target End Date]@row < TODAY(), NOT(ISBLANK([Target End Date]@row)), NOT(Status@row = "Complete"), NOT(ISBLANK(Status@row)), NOT(Counter@row > "0")), "Red", IF(AND([Target Start Date]@row < TODAY(),…
-
Countif with System Generated Date Column on Separate Sheet
Hello! I have a sheet that all projects that are marked as closed are automatically moved to. There is a system generated date field to show when the lines were created so that we know what date each project was closed. I am trying to, in a separate sheet, reference the Date Closed column and return a countifs if the date…
-
Total Time Taken
Good afternoon all, Here we are again, another question about summing up time. I have trawled the forums and cannot find an answer that helps me specifically so I'm hoping that reaching out on here will do so. I have 2 columns - Start Time and Finish Time, the time is put into each in HH:MM format. I would like another…
-
Getting a COUNTIFS Formula to recognise a Date Field
Hi All, I've been trawling through the Forum Archives but unfortunately, I can't quite find what I'm looking for. I have a Sheet where I'm asking it to tally 3 columns so i'm using the COUNTIFS Formula. One of the column's is set as a Date/Time column, however the standard COUNTIFS formula can't recognise the date so it…
-
How to create dynamic rolling month and year?
I am trying to create a table to calculate score from another sheet on a 12 months rolling basis, this data is to be published on the dashboard. It's easy to have the 12th month data which is current month. However this formula doesn't work across the board as shown above, month-9 would be 0. How can I have a formula to…
-
How to write a RYG formula for a range of values?
I am working on a formula for: 1) If cell is empty = Yellow 2) If cell is between -20 to 20 = Green 3) Otherwise = Red How should I write this formula? I am able to get the formula right if it is simpler as follows: 1) If cell is empty = Yellow 2) If cell is 0 = Green 3) Otherwise = Red =IF(ISBLANK([Cell]@row), "Yellow",…
-
Why do my cell formulas not paste when I copy and paste rows?
I have a template, which I have spent a lot of time configuring. I have a set of default rows by product by tier. Once I know which products are launching in a release and what the assigned tier is, I go in and copy that list of deliverables for the given product. When I paste the rows my formulas (which have cell…