Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Drop down lists

Comments

Andrée Starå ✭✭✭✭✭✭

07/29/19

I agree!

Can't wait!

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Date Completed triggers Check Box
I want my user to enter the Completed date and the Check box in the Completed column gets checked. I know this is simple, and I have found answers for the other way, but I want it set this way.
I am trying us an IF statement to populate text in a cell, based off value in previous cell.
=IF(RPN@row > "400", "HIGH", IF(RPN@row < "150", "LOW", "MEDIUM")) Based off the values, the text does not always populate correctly. Example - a value of 5 will come back as "HIGH". A value of 25 shows "MEDIUM". A value of 125 shows "LOW".
IFERROR and OR
I have these two formulas in different columns: =IFERROR(INDEX({Frame ECN Updates Range 2}, MATCH([ECN / PLR / FF / CEG]@row, {Frame ECN Updates Range 1}, 0)), "") =(IFERROR(INDEX({Frame Feedback Updates Range 1}, MATCH([ECN / PLR / FF / CEG]@row, {Frame Feedback Updates Range 3}, 0)), "")) Individually, they each output…