Sign in to join the conversation:
I'm seeking the ability to set a dropdown value (e.g. "New" in "Status" column) when adding a row to a sheet via either manual entry or (more likely) using the Outlook add-in.
Is there a way to do that?
Hi,
Yes, there is. You could have a formula in the Status column, and as long as at least two previous/following rows have the same formulas, it will work.
You might have to restructure the design so the rows would be added to the top instead or add a divider with two rows with the formula because I assume that you'd want to change the Status, and that would delete the formula.
Something like this.
Try something like this.
=IF(ISBLANK(Primary@row); ""; "New")
The same version but with the below changes for your and others convenience.
=IF(ISBLANK(Primary@row), "", "New")
Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.
Would that work?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hi, I've watched number of training videos, specifically to set up PMO. I followed the instructions to download a template set, but it always adds it to a workspace, not the sheets folder. In fact if i download anything it adds it to a workspace, not sheets folder. What am I doing wrong?
I have a sheet that has about 90 columns, but it might only have 12 rows. It would be easier to review reports if I could flip the columns/rows on the report and/or dashboard. Is there any way to do this? Even something using other views.
Hello everyone, Initially, I was assigned to work on a 37-item questionnaire (form) that included 6 nested child questionnaires, resulting in a total of 222 columns. However, as the questionnaire has expanded, the number of items has grown significantly and is now approaching Smartsheet’s column limit. Considering that we…
