-
Help translating Excel formula to Smartsheet formula
I need some help translating a formula from Excel into something that I could use with Smartsheet. The final formula in Smartsheet would end up being a nested if: If Enterprise 2022 R1, give # of months between GA date and Go-live date, if EDIS 2022 R1, give # of months between EDGA Date and Go-live Date, if these are…
-
How to keep a running tally?
Hello! I am trying to figure out how to create a formula to keep track of the Annual Funding Remaining for employees. As you can see with the #CIRCULAR REFERENCE and #BLOCKED I am not having any luck. Can someone assist me? TIA!
-
Formula to sum numerous columns based on the date column
How would I sum more than one column based on a Date of Manufacture column? I want to sum three different columns based on a year of manufacture column Thank you..
-
Copying SUMIF's formula from one sheet to another
I have a few sheets that I need to copy this formula into the Sheet Summary. The formula works in the original sheet (it was AI generated through Smartsheet). When I copy it to the other Sheet Summary, I get "#invalid data type". The formula works for the first two SUMIFS, but when I add the third (Scheduled:Scheduled)…
-
Formula using TODAY when the date field is blank
I am trying to write a formula to assign colors to project tasks. It appears to be including rows where End Date is blank when the criteria is [End Date]@row < TODAY. (Same for [Start Date]@row < TODAY). =IF(Status@row = "{Link to Project Meeting Minutes}", "Green", (IF(AND([End Date]@row < TODAY(), Status@row <>…
-
Formula Help
Hi all, I am creating an invoicing system that is pulling totals from a sheet that shows all paid invoices with a date helper column in it. I want to sum all the payments for each month for a chart. Can someone help me with formula? Thank you!
-
Can the Collect Function be used with a Column reference
I have used the index and collect function successfully when using just a range in the formulation. But is seems like if I try to reference the whole column either as the range or the criteria, then I get the #unparseable value. Reason being that when new rows are added, I want this as a Column formula since the new rows…
-
SLA Calculation Strategy
Background: There are four (4) SLA priorities in the Ticketing intake: Critical = 4 hours: High = 8 Hours: Medium = 24 hours: Low = 48 Hours Using the Created Date (including both Date and Time) I need to create the Planned SLA Finish for each ticket. SLA Plan is expressed in Hours This needs to also be a Date and Time…
-
Using Match of the top parent row to do an index search in another sheet
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
-
Multiple If statements
Hi, hoping someone will be able to help with an issue I am having with an IF formula. I am attempting to build an IF formula from check boxes, however it isn't as simple as multiple IF statements returning their own responses. What I am trying to achieve is a status update column, based off of the checkboxes. And therefore…