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

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…