-
Assistance with JOIN/INDEX and COLLECT function?
Hey Community! What I'm looking to do: I have Part Number and Key Supplier as 2 different columns. When I put in multiple part numbers (the first column), I want to return all of the associated suppliers (column 2). Has anyone done this before?
-
"Filter" by Hour and Minute in addition to day(s)
Hello Smartsheet Community! I have a question. We are setting up a dashboard to display who is on call for specific regions. For some of the regions their on call is easy as it is always Midnight to Midnight but for other they weirder shift times (and people sometimes work "half shifts"). I have my reports for each region…
-
Hi I'm trying to use a formula that works in excel to work in smartsheet
This is the formula =IF([Actual Test Date]1 >= "", "MSA Required", IF(AND([Next MSA ]1 = "x"), "MAS Required", IF(AND([Actual Test Date]1 < [MSA Due Date]1), "MSA Completed", IF([Actual Test Date]1 > [MSA Due Date]1, "MSA Late", "MSA Completed")))) but it gives #invalid operation... It look likes it is using the first…
-
extra space and a comma to remove
I'm using this formula to combine Last, First Names with the Middle name initial (if it exists) and the credentials: =[Last Name]@row + ", " + [First Name]@row + " " + [Middle Initial]@row + ", " + [Degree(s)]@row If there is a Middle name initial, there is no problem and it displays fine. However, if there is no initial,…
-
Can I get a syntax check of the following Credit Amount Formula?
=IF((OR([Invoice 1 Status (Dropdown)]@row = "Credit Memo Required" AND ([TYPE of Credit] NOT(Rebill-Invoice Error))), =[Invoice 1 Amount]@row), (IF(OR([Invoice 2 Status (Dropdown)]@row = "Credit Memo Required" AND ([TYPE of Credit] NOT(Rebill-Invoice Error))), =[Invoice 2 Amount]@row), (IF(OR([Invoice 3 Status…
-
IF OR Statement Return False Value
Hi...I'm looking to close a simple IF OR statement and it seems I'm missing something. 2 values where if 1 or the other is less than 0 return "Red" if false "Green" and returning Green is just getting an error, here is what I have: =IF(OR(IDEA34 < 0, IDEA58 < 0, "Red", ("Green"))) #incorrect argument😫
-
Sheet Summary Formula Help
Hello I am trying to summarise a contact list column, however the problem is that I have a mixture of name and email address (a common problem with this property type it seems). To ensure that I have captured both occurrences, I have tried the formula below, but I get #invalid data type. Is someone able to advise where I…
-
Stacked formula, Data, Symbol and if blank
Hi, I am trying to write a formula saying: If blank then blank If Status column has "Full" symbol Progression to Completed Date column is "Green" Or if Completion Date is greater than today is "Red" Or if Completion Date is less than 7 days is "Yellow" otherwise is "Green" So far I have this, that is working well for…
-
Multiple IF statements with dates
I have two columns with dates (start date and completion date) I am looking to add a formula to a third column status. The status column ideally would have the following Blank if there is no start date In Progress if there is a start date Completed if there is a completion date. Any help would be much appreciated.
-
Dynamic Date Calculation
Good evening! I've tried everything and researched the forums but no luck. I was hoping someone could help out. I am trying to utilize Smartsheet as a scheduling tool, however we have jobs that are shifted around constantly so having the ability to drag rows around and recalculate dates would be extremely useful. Starting…