-
Calculating Total Working Hours between Sign In & Sign Out
Hello, I'm facing difficulty of summing up Total Working Hours in the worksheet. I'm working on calculating a simple total working hours for my employee, they just fill in Smartsheet form then the worksheet will calculate it. I need help on which solution work best on this project. Below I provide the details: Employee…
-
Pie Charting a Sheet Summary Report
I have added a RAG status to all my projects in the Sheet Summary view. I can pull a report showing the projects and their RAG status fine. When I then try to pie chart the RAG status onto a dashboard this is not possible as the RAG status is not a number. So I added a number field and populated it with '1' so that I can…
-
Formula to include verbiage based upon selection
Hi all, I am working on a sheet in which I need a formula that when a status is selected in one column that additional verbiage would pre-populate another column. The picture below in the status column, when I select the word "cancelled", I would like the comments column to show the word "event is not going to happen" I'll…
-
Relative Default Date in Forms
I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this? ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can be overridden by the user - say they give us 1week instead - 5/6 that should be good.…
-
ISNA Excel Formula
I am trying to recreate an excel formula in Smartsheet that looks for the column Header word in the proceeding columns within that same row. If it finds the word in that row, it then places the word in the cell that the formula exists. So if the formula is in [Apple]1, it searches a specific range of columns in row 1 for…
-
Can you auto populate task dates based on the entire project end date?
I have different marketing tasks where their completion dates revolve around an entire projects completion date. For example, there are tasks that need to be completed 10 days before project completion date, 20 days prior, 30 days prior, etc. Is there a formula I can use that auto fills task due dates based on the project…
-
Complex formulas ammendment
Hi All, I have an existing Smartsheet that has some relatively complex formulas to count the the status of an action as there are several conditions for an action to show as "Open" and "Overdue". Over the last few days, we have modified the sheet further by adding columns and each added column now comes under as added…
-
Highlighting Gantt Chart Date Columns
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspension period. Is there anyway to do that? If not, can I submit that as a feature…
-
Possible to create multiple linked templates?
Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate report sheets. Without cloning and linking it all up again, I was wondering if there was a…
-
Multiple IF/AND for duration and status
Hi Community, I am trying to structure an IF/AND formula to reflect the following conditions: IF [Duration]@row <> 0, AND IF [Complete]@row =0, "Not Started" IF [Duration]@row <> 0, AND IF [Complete]@row =0, AND IF[Complete]@ previous row = 1, "In Progress" IF [Duration]@row <> 0, AND IF [Complete]@row =1, "Complete" IF…
