Multiply fields with formulas

I have 2 cells that I would like to take the output of the formula in each cell and multiple. I did the standard formula in the Pay cell but I am guessing due to my formulas in the other cells is causing an issue.

Pay rate formula: =IF([Client Name]@row = "Weekend Stay", "$150")

Total Hours formula: =COUNTIFS([Saturday Stay]:[Saturday Stay], 1) + COUNTIFS([Sunday Stay]:[Sunday Stay], 1)

Pay: =[Pay Rate]@row * [Total Hours]@row

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

https://community.smartsheet.com/discussion/141185/multiply-fields-with-formulas

Hi,

I hope you're well and safe!

Try something like this.

=IF([Client Name]@row  = "Weekend Stay", 150)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

All comments

JR90

Hi Angela

Remove the $ sign from the first formula, I think that's what's throwing it off. You can set the pay rate column to be currency.

In the pay column you should just be able to use this formula:

=[Pay Rate]@row *[Total Hours]@row

Angela L

that didn't work, still have the same error

Andrée Starå

https://community.smartsheet.com/discussion/141185/multiply-fields-with-formulas

Hi,

I hope you're well and safe!

Try something like this.

=IF([Client Name]@row  = "Weekend Stay", 150)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.