Is it possible to use a workflow to import a formula?
Hi ,
I'm quite new to Smartsheet and have been playing around with it,
I recently created the following workflow to "sort of" import a formula when another column gets updated
the idea behind this , is to update a cell after the new size has been added.
it seems to work to some extent how ever it leaves a ' before the formula , and I have to manually remove it.
My 1st thought was to create a formula where if the Colum is blank it mustn't do anything and only update when the new size is entered.
IF(ISBLANK(Mailbox Size after Archive(GB) (WHOLE NUMBER)@row), "",=[Mailbox Size after Archive (GB) (WHOLE NUMBER)]@row
Kind Regards
Brandon Austin
Best Answer
-
I hope you're well and safe!
Unfortunately, adding a formula using a Workflow is not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- Add a so-called helper column (Checkbox) and use the Update Cell Action in a Workflow and then have the formula reference the helper column and activate if it's checked.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
Answers
-
I hope you're well and safe!
Unfortunately, adding a formula using a Workflow is not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- Add a so-called helper column (Checkbox) and use the Update Cell Action in a Workflow and then have the formula reference the helper column and activate if it's checked.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
ah, I thought as much . hope we can get that function in the near future. will submit the idea
Thanks @Andrée Starå
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!