Formula based on labor rate

Options

Sidonia Posteuca

Sidonia Posteuca ✭✭

11/29/22 in Formulas and Functions

I am trying to generate a formula to calculate an amount based on a labor rate that is based on the project/site.

What would be the best formula to generate the correct amount?

0 ·

Answers

Mike TV ✭✭✭✭✭✭

11/29/22
Options
@Sidonia Posteuca
More information is needed. However, I'm not even sure what to ask you to provide. How would you do the math on paper?

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to count unchecked boxes for rows with data only
I tried this formula but it's also counting the unchecked rows without data =COUNTIFS([Client Lost?]:[Client Lost?], 0) What should be the correct formula?
Risk Rating Formula
Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those selections I want to have a 3rd column which is the output of the formula, Rating, designated High, Medium, Low. Below are the…
COUNTIFS with multiple inputs and dates
I'm trying include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set. =COUNTIFS(DISTINCT([Name of Requestor]:[Name of Requestor], [Submission Date]:[Submission Date], AND(@cell > DATE (2023, 9, 30), @cell <= DATE(2023, 12, 31))))…