Best Of
Re: August Question of the Month - Join the conversation and receive a badge
What’s the best thing you’ve seen on the Smartsheet Community platform?
I am always happy to see when users offer a solution that isn't pushing a third-party integration. A lot of us work in rigid corporate environments where we don't have the option or flexibility to introduce an add-on from a new vendor. Creative ways to customize the Smartsheet core features or preparing samples from the EAP have been great ways where the Community platform shines.
ss_innovation
Re: Printing Gantt stuck in Quarters
Hmm, mine prints or exports just the same as it shows in my gantt chart within Smartsheet. Here's a few suggestions:
-I would double check that you have your gantt chart zoomed in or out as needed:
-If that doesn't fix it, you can go into the Project Settings (gear will appear in gantt mode in the top right corner) and adjust "Gantt Timescale Settings" as needed
-If the problem is still persisting beyond that, you can always reach out directly to Smartsheet Support:
Hope this helps!:)
brianschmidt
Re: Esc triggers a refresh and loss of work
Thanks, Debbie. While not a fix, it does make me feel a bit better. You know: misery loves company 😕
~Rod
RBro79
Re: Highlight new row
Thank you @Naeem Ejaz @Andrée Starå and @Paul Newcome
I'll try the created date helper column.
Paul's solution will only work for me, but will not work for others that need to view the sheet. everyone needs to see the highlighted rows. I appreciate your help Paul!
thank you! This is the best community…so helpful and responsive! Have a wonderful week!
noshiro
Re: RACSI/RACI Matrix with Conditional Formatting
@Trang Turtletraxx Bummer.
Well, it's here for anyone else that has the same situation. Sounds like you'll have to clone them all and update the cells manually.
Maybe you can get your company to make an exception if you describe how much time you'll be saving ;) . It doesn't interface with the API, everything stays local in your browser so it's very secure. @SSFeatures can expand on that if it helps your case.
Darren Mullen
Re: RACSI/RACI Matrix with Conditional Formatting
Hi,
I hope you're well and safe!
I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Is that an option?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: RACSI/RACI Matrix with Conditional Formatting
@Trang Turtletraxx Yes! Using a handy browser extension, it has an option to easily do that for this specific use case.
I linked to the point in the video that is of most interest to you:
Darren Mullen
Re: Multiple IF statements with > / < constraints.
Hi @JoHaan
To create a function using IF and AND, you need to put the AND function at the start and then the two pieces of logic, instead of writing "and" within the logic. Like this:
=IF([Risk Priority Number]@row < 48, "Non Relevant",IF(AND([Risk Priority Number]@row >= 49, [Risk Priority Number]@row <= 89), "Minor"))
Not
=IF([Risk Priority Number]@row < 49, "Non Relevant",IF([Risk Priority Number]@row > 49 and < 89, "Minor"))
However, because the IF functions are nested the second one is only evaluated when the first is false, so you do not need the AND.
This is much simpler:
=IF([Risk Priority Number]@row < 48, "Non Relevant", IF([Risk Priority Number]@row <= 89, "Minor", IF([Risk Priority Number]@row <= 124, "Major", "Critical")))
It means:
If Risk Priority Number <49 is true then return "Not Relevant", if false, evaluate the next IF
…IF Risk Priority Number less than or equal to 89 is true then return "Minor", if false, evaluate the next IF
…IF Risk Priority Number less than or equal to 124 is true then return "Major", if false, return "Critical"
Note - In your example, if the Risk Priority Number is 49 or 125, nothing would be returned. So I used less than or equal to , rather than less than.
Hope that gets you going. Enjoy!
KPH
Re: Multiple IF statements with > / < constraints.
@KPH beat me to it, but I agree 100% with their recommendation. To make a small addition, mostly because I already had it typed… this will also setup the prefix mentioned in your comment:
=IF([Risk Priority Number]@row <= 49, "Non Relevant " + [Risk Priority Number]@row , IF([Risk Priority Number]@row <= 89, "Minor " + [Risk Priority Number]@row , IF([Risk Priority Number]@row <= 125, "Major " + [Risk Priority Number]@row , "Crit " + [Risk Priority Number]@row )))
Carson Penticuff
Re: Multiple IF statements with > / < constraints.
Good catch @Carson Penticuff
If this was an exam, my teacher would be very unimpressed with me missing part of the question.
May I redeem myself by offering a slightly shorter way to add the number to the prefix (which I find easier to edit*)?
=IF([Risk Priority Number]@row < 48, "Non Relevant", IF([Risk Priority Number]@row <= 89, "Minor", IF([Risk Priority Number]@row <= 124, "Major", "Critical"))) + " " + [Risk Priority Number]@row
*For example adding a hyphen to separate the suffix, or adding another part to the string, can be done in one place now.
KPH