-
Formula to split up / break down long strings of text
Hi, Hope you're all keeping well. I was hoping someone could point me in the right direction of a formula / function that can help break down large sections of text. If someone could point me in the right direction, I should be able to work out the nuances and implementation myself. I have an API that exports data into a…
-
Activate/Deactivate a Checkbox
Is it possible to activate/deactivate a checkbox, based on the value in another cell? For instance, I have a sheet where users enter data via a form. Then there is a "DQ_Check" column with an IF statement that returns "TRUE" or "FALSE" to indicate that all required fields are valid. If that statement returns true, I want…
-
IF/AND formula
I need to calculate the number of Network Days based on a Leave Status but if a half day has been checked, it needs to just put 0.5. The formula I am currently using is: =IF(AND([Half Day]@row = 1) [Leave Type]@row = "TOIL", "0.5", NETWORKDAYS([Start Date]@row, [End Date]@row)) But I'm getting a #Unparsable error. What am…
-
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)…