Nettet12. 1.5K views 11 months ago. If you need to return multiple results into a single cell using multiple matching criteria in Smartsheet, then a JOIN COLLECT formula is what you need. Nettet2. feb. 2024 · JOIN's first argument is a range. Smartsheet's ranges do not accommodate what you are trying to do (three non-contiguous cells) You will need to just concatenate …
Check Box & IF Statements — Smartsheet Community
Nettet16. okt. 2024 · Welcome to the Smartsheet Forum Archives ... To combine IF and AND statements you have to close the AND statement before you put the THEN statement. … Nettet14. sep. 2024 · On the Sheet Summary I'm trying to write a function that will track Past Due tasks below is the format : =COUNTIF ( [Is Past Due?]: [Is Past Due?], "Yes") The formula doesn't work as it says "UNPARSEABLE". Below is the Past Due column name smartsheet-api smartsheet-api-2.0 smartsheet-c#-sdk-v2 Share Improve this … top rated water based fence stain
Smartsheet function is UNPARSEABLE - Stack Overflow
NettetSmartsheet is an Equal Opportunity Employer committed to fostering an inclusive environment with the best employees. We provide employment opportunities without regard to any legally protected status in accordance with applicable laws in … Nettet21. aug. 2024 · August 21, 2024 Parse Smartsheet Multi-Select Dropdown Column Into Individual Cells Parse Smartsheet Multi-Select Dropdown Column Into Individual Cells Below are the Formulas I used for this sheet by Column: Quantity Fruits Selected: =COUNTM ( [Fruit Multi Select]@row) Fruit 1: Nettet19. mai 2024 · In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. ... Smartsheet functions list. Categories. 23.5K All … top rated water filtration pitchers