-
Conditioning logic to be AND not OR in form
Hi there, I am needing to build in logic to a form whereby a question shows if a specific answer to 1 AND 2 is selected and not OR. Question 1 : A, B or C Question 2: X, Y or Z Question 3: Appears if answer to Q1 is C and answer to Q2 is Y. Currently this is showing if answer to Q1 is C or if answer to Q2 is Y. I need it…
-
How to Consolidate Entries from Multiple Forms
I've seen this question asked before, and the same answer is always given, "use an update request." Is there a way to consolidate information, because I don't think update requests are the best solution for our process. I have multiple forms with different types of information being entered at different times by different…
-
Embedded IF and IF Error Formula
Hi there, I'm trying to use an IF and IF ERROR formula with an embedded index + match formula, so that if doesn't find the information on the one reference sheet it looks at the next sheet and then the next sheet. =IF(IFERROR(INDEX({B16.P21 QF}, MATCH([Function/Task ID]@row, {B16.P21 ID}, 0))), IFERROR(INDEX({B16.P20 QF},…
-
How to consolidate a document that has blanks
Hi, I have a grid I stored comments on questions from customer. some question may not have been answered so it results in the cell being blank. I would like to get to another document where all the available answers are consolidated, with no blank cells. Below a screenshot of an example document. so ideally I would like to…
-
Nested IFs using AND
Basically I am creating a report on our Asbestos Register requested by our H&S team basically they would like the following but in a formula. If total score is greater than 15 display "Band A" if total score is greater or equal to 10 display "Band B" if total score is less than or equal to 14 display "Band B" if total…
-
Impossible to visualize groupings more than 2500 rows...
Hi, Im searching over the internet a variety of things (data) from a variety of types (countries, format, source, etc) and some of them are validated (true) and some dont (false) and inserting this information in a Smart Sheet page. On the other hand, I have this REPORT, reading from that sheet i have just mentioned, and i…
-
Populate Smartsheet Column from another Smartsheet Column
I am creating a batch of PM sheets. Some of these sheets have columns that will be the use throughout, like Team and Organization. I have sheets where Team members and organizations will be defined. I would like to be able to link the entries in the columns from the Teams and Organization SmartSheet and populate the…
-
Subtracting Dates to determine what is less than 90 Days
Maybe I need to use a different formula, but this was successful in returning "Short" for everything, rather than anything under 90 days. We are trying to call out short start projects or those that require less than the average 90 days, so a difference of 90 or over should return nothing. =IF([Anticipated Activation…
-
Reassign Contacts with Automation
Our accounting team regularly reassigns projects to new managers/staff and I need to find a way to automate the change once a date has been reached. In the example below I would want the contact to change from Joe to Jim once the Estimated Transition Date has been reached. The problem is I need this to be a 1 time write…
-
How to count if cell A is blank and cell B has text?
I'm trying to write a formula so that I will count something if the cell in column A is blank and the cell in column B has text. How would you write that out? Thanks!
