Spoonhead
Spoonhead
-
Re: Hyperlinks and Conditional Formatting on Date
To work around this, you can use a formula to manage the highlighting based on the expiry date without directly involving the hyperlinks: Create a Helper Column: Add an additional column (let's call …1 · -
Re: Formula for pulling in names based on different fields counted?
We can use the INDEX, MATCH, and COLLECT functions to achieve this — Name (employee) with the highest vote count per value: Assuming your data is in a sheet named "SourceSheet" with columns…1 · -
Re: IF(AND(MATCH() Between Different Sheets Formula Assistance
You should be able to achieve this with a combination of IF, MATCH, and INDEX. Ensure you have two sheets, Sheet A and Sheet B. In Sheet A, create a column for the checkbox. In Sheet A, use the follo…1 · -
Re: Dynamically update Health column using Symbols based on proximity to Due Date
The formula you need should consider the difference between the current date and the due date. Smartsheet formulas do not use ELSE IF statements, but rather nested IF statements. Also, when using dat…1 ·
