-
Event Registration with Form & Summary
I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
-
Different columns with the same name ?
How can i make several columns with one same name???
-
Custom Template
Hello, I'm looking for a SmartSheet expert to build out a custom Project & People KPI report template, I know what I want to the end result to looks like but I would rather work with someone that I can share my vision and they can use their expertise to make it happen. Let me know if you would like to have a conversation…
-
Soooooo Lost - Cant Figure Out A Formula
Hey Everyone, So glad I found this community! I am currently trying to create a formula and am struggling severely with it! :( I have multiple tasks that need to be performed. Task 1 may take X days, once its finished and only once its finished then Task 2 can begin and will take X amount of days and so on for multiple…
-
Sending a Row
Is there any way to see the history of ROWS that have been shared? When you send someone an Update Request, its documented in the Update Requests tab with who it was sent to and the date sent, etc. Is there a similar history shown anywhere for the individual rows that are shared?
-
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
-
MS Project Budget Reports and Smartsheet
At my organization we are currently trying to transition from MS Project to Smartsheet. Currently, using MS Project we are able to use a resource pool (every resource is added based on hourly rate, etc) and we are able to generate budget reports automatically. Is this feature something that is available on Smartsheet as…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
Cell Link from web form
Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet. I used the workout of providing the cell background color to white to…
-
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…