-
i need help creating a formula
I have this row with dropdown options that contain the Quantity and the Price. I want the formula at the end to generate the Total $ for that row so the customer knows the total for the items they want. How do I do this?
-
Formula Issue - Invalid Operation
=IF([Time Due]@row > [Day End]@row, [Day Start]@row + ([Time Due]@row - [Day End]@row), 0) Getting an "Invalid Operation" with the above and cannot seem to see it. I really think I have been looking at this Ticketing solution for too long.
-
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..
-
Cross-sheet references maxed out
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
-
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…