I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", …
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a su…
Hello fellow marketers! My name is Kevin Branscum and I am the Marketing Solutions Manager here at Smartsheet. I've spent my career in various marketing roles (brand marketing, product marketing, crea…
My company currently has two separate department that uses two different systems. My department is using Smartsheet and the other department is using Google Sheets. Is there a way for the two systems …
I have a dashboard with two web content widgets of the same sheet using a card view. I want to be able to have one only show the completed cards and have the second only show the in process cards. I h…
Hello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it t…
I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amou…
I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for…
I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of s…
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:…
