I want to be able to type in the field if the Value is False. I can copy the formula to all the field in the column and overtype the formula. but if I convert to a column formula then I cant do this. …
Hello, I created active project and archive project sheets. When a project is completed, it is automatically moved to the archive sheet. I set up a timesheet that references both sheets and looks for …
How do you write a function to see if all boxes are checked on a row with multiple checkboxes? I tried using the SUMIF(Check_Box_1@Row = 1) and attempted to use a total number of checks to evaluate, b…
Is their a way to use the COUNTIFS as an OR. Currently, it will count all conditions of a cell that match the conditions given. =COUNTIFS([Clothing Item]:[Clothing Item], "Jacket", [In Stock?]:[In Sto…
Do Smartsheet Sheets have Data Validation functionality like Excel? I'm looking to preserve the order-of-operations and to ensure my automation triggers after users fill out 2 drop down cells, a text/…
Hi, I'm having trouble getting this formula, I've tried a lot of options and am probably over-thinking it. In the image above, what I want to return is the 5% value. I have a helper row at the top und…
Hello, I am trying to populate Total Points from Sheet 1 with a formula. I would need to do a multi-value vlookup for my Sheet1[Color] and grab the related points from Sheet2[Color] and SUM them into …
Greetings! I am seeking assistance to create an IFERROR/INDEX/MATCH formula that will look for an EXACT match of an Account ID between two Smartsheet. In Smartsheet 2 below I have an Iferror/Index/Mat…
Looking for the proper way to return multiple values using INDEX/COLLECT. I'm assuming JOIN needs to be in there but can't get it to work! Both without and with JOIN, the formula still produces the fi…
Greetings! Reaching out to this group for assistance in creating a formula that counts the number of times a certain Product is associated with a given Account ID. The challenge is that the Account ID…