-
Help with Bulky Formulas/Formatting?
Hi all, I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. Currently, I have a hidden column set up to test if PO…
-
Formula for Countdown
Hi, I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error. Am I missing something? Please help! Thank you!
-
Formula calculating revenue for Q2
I am trying to calculate revenue for Q2 only for a given property Here's what i had in the cell =SUMIFS({Garden Grove Bill Rate}, {Garden Grove Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Garden Grove Inv Date}, MONTH(@cell) > 3). But that formula doesnt work now that we are in july. as it calculates july revenue as well. So…
-
Totaling percentages linked from another sheet
I am simply trying to get an average percentage in a parent row from children rows that are linked in from another sheet. Is the fact they are linked what is causing my error? Currently I'm just using: =AVG(CHILDREN())
-
eliminate INVALID DATA TYPE when using a IF statement to display the month
I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE. I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE? Here is my IF Statement…
-
Nested IF statement is giving me an UNPARSEABLE error
Hi, I'm using this formula: =IF(COUNTIF([Pilot Status]10:[Pilot Status]12, "No") > 0, "No",IF(COUNTIF([Pilot Status]10:[Pilot Status]12,"Hold")>0,"Hold","Yes"))) to show a "No" Symbol if there is at least 1 "No" in the range, if there are zero "No" in the range, then i want it to show a "Hold" symbol if there is at least 1…
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Formula Training
I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas. I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want to give him some samples to…
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
How do i get symbols to appear instead of the word representing a symbol?
Hi, I am attempting to write an IF statement with the result being that the "Pilot Status" cell will have one of the symbols in it. I have formatted the field to show symbols, and I've written the formula to use the representative words, but i'm still only seeing the word show up in the field. HELP My Formula…