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", …
Hello Everyone, I am trying to build a Dashboard, several teams in my Org. can use. The idea behind this is as follows: There is a separate sheet, which gets filled by using forms / row update. Each T…
I have designed a workflow for our team and used the Request system workflow as a start. I created a report and attached the link in the email when someone submits the form. I have this report linked …
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:…
Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the be…
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have childre…
Starting 7/30/18 we noticed that using either the keyboard shortcut or the right-click option to cut a line within a SmartSheet would sometimes leave behind the original line (acting more like copy th…
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arrange…
Hi, When I do backup of my Smartsheets, all of my files that were attached to any rows are saved to a separate folder. That's fine, but my problem is, I don't know which rows those files were attached…
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the r…