-
Allocation time per assignee for same task
Hi, I'm new to Smartsheet. Is there a way to add number of hours when you have more than one person doing same task. Thank you!
-
Unique Alerts
I have a sheet where when a user fills out a form they check the first person the task is assigned to when that person completes the task they uncheck their name and check the next person who has a task to complete. So I have alerts set up to send emails when their name is checked. The alert is set up like: "Send Joe and…
-
Employee Management
I am looking to start a smartsheet to track employees and when they work. What I am looking for is a management sheet that can list all my employees, their titles, pictures, tasks and most importantly for this sheet their work schedule. I own a Martial Arts School so I have 26 employees over two schools working full time,…
-
Can Smartsheet to perform a Mod Function?
I am a network engineer and I am importing an excel spreadsheet into smartsheet. My spreadsheet is an address calculator for quiclky identifying IP addressing for my organization. My spread sheet has the use of the "MOD" function and is contigent upon using this function. I am aware that the "MOD" function provides the…
-
Referring to Dropdown value in a formula
Is there a way to set the value of a dropdown in Column A from a formula in Column B? This is my formula; Column A = Status3 Column B = Expiration Date =IF([Expiration Date]3 > TODAY(), Status3 = "In Force", Status3 = "Pending") It gives me #INVALID COLUMN VALUE error message in Column B Any help would be appreciated.
-
Resource Mgt
Im new to this. If we have one resource alloocated over several sheets and in one sheet/project the resource is required for an extra day, How do we link so that all associated sheets dates are updated? thanks
-
Creating a new template
I just moved my team over to smartsheet (off of excel), so I'm still learning. Is there a way to create a new template with custom columns so that my team can have a consistent custom template to start projects with?
-
IF/AND Functions
I am trying to create a sheet that will auto update a number in a cell using multiple IF AND statements. Is it possible to have multiple IF(AND statements in one cell or what is the format? When I have one statement it works properly, but I cannot figure out how to have it work with two or more. I am not worried about the…
-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
-
Sales Template Help
I’m using template, “Sales Pipeline by Rep”. Instead of using Rep name as the main category, I would like to use the Account/Company name. This way I can sort opportunities by the customer name. * I would like the total sum values to still sort by category (which is now customer), but filtered by status. Only the items…
