-
Convert Text into a Symbol
Hi All, I am having great difficulty with what I think is a fairly straightforward formula (One of those days I think!). I have a basic Smartsheet containing two numbers. If one number is higher than the other or vice versa I want to bring in a Symbol pointing either up/down. I know the text to show a symbol is up, down,…
-
When checked box, don't count line in total Formula
Hi there i have an expenses sheet. Once the expense has been submitted the manager approves these expenses, accounts then can log in and check the expenses are authorised prior to repaying the staff member. Is there anyway when the processed box is checked it removes the line from what's due in the totals? Thanks again
-
How do I correctly use Sum & Value formulas together?
I'm trying to get the total monthly parking charges for my office. I have a column showing each individual's monthly parking charges, if applicable (enabled or disabled). For the sheet summary, using =sum([Monthly Cost]1:[Monthly Cost]84) doesn't return anything but 0 because the column is using text. I've tried adding the…
-
Can you create a formula for, 'If 'task name' is from another sheet, then insert flag symbol'?
I am looking to easily identify which tasks have been linked to a question sheet and added to the project plan.
-
Combining IF(AND & IF(OR Statements
I have 2 statements I m trying to combine to answer the question: Is an Extension Required? =IF([Extended Due Date]@row > [Due Date]@row, "Yes", "No") =IF(AND([Due Date]@row < TODAY(), [Extended Due Date]@row = "N/A"), "Yes", "No") Both statements work, but I need them combined. Please help
-
Unparseable error with "IF"
Good day everyone, I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here. Here's the formula that I'm using: The thing what I want to do is if the Growth is over 100%, I want the result ">100%" in the cell. If not, I want the result of…
-
Adding IFERROR to another IF Statement
I am trying to add an IF ERROR statement to the formula below so that it is left blank instead of saying "#invalid data type". I'm struggling to make it work and would appreciate any help. =IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) +…
-
Distinct and Collect with Arrays
I am looking for the syntax for a COUNT, DISTINCT, COLLECT formula that will count number of distinct values in an array of cells, but only in rows that have a certain value in another column. For example: Active Status | Required1 | Required2 | Required3 A | PSY 101 | PSY 102 | ACC 233 I | BUS 212 | MHT 232 | ACC 314 A |…
-
COUNTIFS using current month
Hi all, I've been doing some searching on here and can't find the solution to my issue. I have a smartsheet which has four columns. Three of them may have a name (text/number), the fourth is date only. I'm trying to run a formula that detects the total count of name X from columns 1-3, in the current month. My formula is…
-
Formula/Automation for copying Finish date to a new date column
Scenario - There is no existing finish date in finish date column. I add a finish date. There is another date column present. Inquiry - is there a formula/automation to copy that finish date to the other date column only once and never copy it again?