-
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…
-
Compare Text between columns, one with text, one without, and return the text.
I have created a form that is for use with two separate groups, fields become available dependent on how respondents answer questions. I have a VLOOKUP formula set to pull in the address information from another sheet. Because this is used between two separate groups, there are two name fields. I am trying to compare both…