Formula to make percent complete row = 100 if done is checked

Jennifer Flanagan

Jennifer Flanagan ✭✭

07/10/20 in Smartsheet Basics

Want the % complete cell to automatically turn to 100% if the Done cell is checked

Using below but not working

=IF([Done]@row =1, [% Complete]@row, = 1)

0 ·

Answers

RossL ✭✭✭✭✭✭

07/10/20

@Jennifer Flanagan
Try this in the % Complete Cell
=IF(Done@row = 1,1,0)

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Interactive Dashboard without Dynamic View?
Hi, I have a sheet where the user enters a code which then brings back metadata from other sheets. I would like to have this field on a dashboard so the end user doesn't have to navigate to the sheet but enters it in the dashboard (which is the field in the sheet itself). I have searched and I think this is possible with…
Logic performance and default values with 3 drop options
On my form- Field question "Attention Needed" has 3 options, "OK", "NEEDS ATTN", or "Out of service". I have twelve subsequent fields that have options either "OK" or "NEEDS ATTN". I am having a problem with the logic and performance of those answers, perhaps I have the structure set up wrong. If field question "attention…
PDF Text Field Scroll Bar Not Working
Hi, I converted a word document into a fillable PDF. I set up all the text fields in the PDF so that Scroll Long Text and Multi Line are checked in the properties options. When I type a long paragraph in the PDF where the text overflows the text field box, the scroll bars work as they should, and I can see all the text in…

Help shape the future of Smartsheet.
Share your ideas and feature requests.