formulas in update requests

Hi, i'd like to use smartsheet for end of year bonuses. I ideally would like to send an update request to managers with the info below. I can lock all cells so that the only one they can update would be column C - but is there a way on either update request or something where if they change the drop down of column C a new value in Column D shows? Or what is anyones recommendation?

Column A: Employee Name

Column B: Weekly Salary

Column C: Bonus in weeks (Drop down 1-4)

Column Amount of Bonus (this is a formula taking Column B X Column C

Find more posts tagged with

Forms

Conditional Formatting

Update Requests

Comments

Andrée Starå

Hi,

Unfortunately, there isn't a way to do that natively in Smartsheet at the moment.

You could set it up with the help of third-party tools. Google Forms is one example.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You could use a basic =[Column B]@row * [Column C]@row to get what you need. If the formula is already in the row before sending the update request, it will automatically calculate based off of what is selected in Column C.

I tested this with a very basic version. Here's the set up:

Number1 Number2 Total

=[Number1]@row + [Number2]@row

I then sent myself an update request and only included the Number1 and the Number2 columns. I updated each to 10 and submitted. When I returned to the sheet, it looked like this:

Number1 Number2 Total

10 10 20

So short answer... Yes. What you want should be a pretty basic solution.

Long answer... See above.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…