IFERROR Problem

Alexandra Prescott ✭✭✭✭

03/28/22 edited 03/28/22 in Formulas and Functions

0 ·

Answers

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.
Mass Remove Hyperlinks
Is there a quick way to mass remove hyperlinks within specific columns on a Smartsheet? I do not want to "clear content", just remove the hyperlinks.
Can you collate Ancestors based on another column condition?
Hi all, looking for some formula help. I would like to collate the names of my ancestors for a task in my "Stage" column, but only if the Hierarchy level of that parent or grandparent is >= 3. I have tried utilizing the Join(Ancestors(Task@row), " - ") and this returns all of the parent tasks. When I try to utilize an if…