Adding resources cost

Noga Ginzburg

Hi all,

I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it?

I think this is the solution for my issue which is i want to add the costs to my resources and I couldn't find the best practices for that. Would love to hear any tips and recommendation.

Thanks,

Noga

Andrée Starå

Hi Noga,

Unfortunately, it's not possible at the moment to set a bill rate in Smartsheet, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could either set up something similar as below or take a look at another solution from Smartsheet called, 10,000ft (will be integrated with Smartsheet soon)

More info:

10,000ft by Smartsheet

https://www.smartsheet.com/platform/10000ft

Resource management software for stronger teams and more successful projects.

Time Tracker with Rate Table

https://www.smartsheet.com/marketplace/templates/time-tracker-rate-table

Get free COVID-19 resources, including templates, webinars, and community. Learn more here.

Would any of those options 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 help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

rgochee

Noga,

What you can do is create a Resource Sheet which can contain the Resource and their Rate

Then on your other sheet where you assign the task and hours you can us and Index - Match formula that will pull in their rate.

Here is the formula used in this example =INDEX({Resource for Hourly Range 1}, MATCH(Resource@row, {Resource for Hourly Range 2}, 0))

Please let me know if this is a solution for you