-
Fill in a cell based on another cell's value?
Hello, I'm tracking participation of a program on my sheet as a "participation %" column. There is another column called "participation status" to make it easy for the managers to know if their employee is on track with participation or not. I'm trying to set up the participation status column so that if the participation…
-
Convert the text "yesterday" to a date format.
I downloaded some issues from Jira and I have a column from there titled "Last Updated". In that column it has the regular date format but also text that reads "Yesterday" or "Today". I figured I could use the TODAY() formula to convert the today dates, but how do I configure that to convert to yesterday? Is it TODAY(-1)?…
-
Hi, I am trying to do a SUMIFS, and I keep getting incorrect argument set
I have a column called Actual Charges I want to sum if the column SOW Reference has "IPO PMO" in it. I thought I was following the syntax and reduced to only one criteria. I do have other criteria, too. Please see formula below. I also wanted to sum the whole column Actual Charges, but it seems to only capture the column…
-
If all Child rows = "Complete" change Parent to "Complete" and send to new sheet
Hello! I have an automation that sends "Complete" Parent columns to a new sheet (my "Closed Orders" sheet). I also am setting up a formula for when all Children status' are set to "Complete" it automatically switches the Parent row to "Complete". What I am wanting to do is send ALL rows including Parent and its Children in…
-
Automatically change Parent status to display Children status; still be able to change Child value
Hello, I have this formula =IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(AND(COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), COUNTIF(CHILDREN(), "") = 0), "Completed", IF(OR(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), COUNTIF(CHILDREN(), "Not Started") + COUNTIF(CHILDREN(), "") =…
-
Automated Reminders
I have created a timesheet Smartsheet that managers are supposed to fill out for their employees each month. Each sheet has multiple lines one for each employee. How do I set up daily reminders for them to fill it out (including a link to that month's sheet)? I already have it set to only send reminders when my sheet check…
-
How to have child rows calculate health and then roll that up to parent rows with different criteria
Hello, I have a "Profile Health" column that is measuring the health of all rows using this formula: =IF([Copy in File]@row = 1, IF(AND(Expired@row = 0, [At Risk]@row = 0, Current@row = 0), "Green", IF(Expired@row = 1, "Red", IF([At Risk]@row = 1, "Yellow", IF(Current@row = 1, "Green", "")))), "Red") but this should really…
-
Error Using Max Function
Having an issue with the Max formula. Appreciate any advice the community can provide. This formula is giving me an Invalid Column Error: =MAX([End Date]195:[End Date]220) However, this one works fine so I don't see why there would be an invalid column error on the first formula. =NETWORKDAYS([End Date]207, [Start…
-
Auto Generate Task List based on Criteria
I am wondering if there is a way to trigger a task list to start when criteria is met? The task list is built and made into a template. I am wanting to trigger the activation or start and rename of this when the contract column in my schedule is changed to NTP. The file name would change to my Job Code which would be @row.…
-
Is this the right formulas for Expiration Dates?
=IF([Land Owner/Tenant]@row = "Owner", IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF(OR([Buyout Closing Date]@row <> "", [Vacancy Inspection Date]@row <> ""), MIN(IF([Buyout Closing Date]@row = "", 99999999999999, [Buyout Closing Date]@row), IF([Vacancy Inspection Date]@row = "",…
