-
Counting Number of Times a Predecessor is Used
Hi, Long story behind this one, I'll try to keep it short. On Smartsheet, the critical path tool isn't working for my sheet because our project has too many hard deadlines and we are not using enough predecessors; however, we need to be able to view a critical path, so I have accepted that I will have to create one…
-
Populate Row based on a pulldown selection.
I maybe shooting for the moon on this. I am building a meal planning tool. I have a sheet that has the name of the recipe and then several columns that are the ingredients of those recipeies. in the ingredance columns i have placed a number that represents how many of that ingredant is needed. I have a second sheet that…
-
Date based on another date
Hi All, I am new to this and was wondering if anyonecan help me with a date formula? I have a column 'Urgency' that uses dropdown choice - Critical, Urgent, High etc. Each choice has a set amount of time to be completed... Critical = 1 day, Urgent = 2 days etc. I have a 'Due Date' column that I would like to be populated…
-
Hours NOT adding up to correct number of days
I'm having a challenge where the total number of hours is not adding up to 1 day if the hours are equal to the "length of workday" under my settings
-
Updated cells automatically highting in Pink
Is there anyway to stop updated cells being highlighted in pink for 1 hour after they have been updated? THe reason being is because whilst it is pink it is not possible to update the cell colour to anything else which is fustrating. woudl appreciate some help on this brook
-
copy rows with formula's
When I copy a row from one sheet to another sheet; all the formula's in the cells are replaced with values in the target sheet. So my formulas are gone in the new row that appears to the target sheet. Is there a way to have the formulas copy over in the row so they are intact in the target sheet?
-
Formula's for [Start Date] column when dependencies are enabled
Hi, I am currently trying out Smartsheet in order to decide if we will be able to use this at our company or not. I'm using the construction timeline with gant chart template. I would like to add project management fee payment dates as milestones. Payment #1 linked to start of the project -> OK, no problem Payment #3…
-
Automatically create multiple rows in a smartsheet
I'm creating a couple of web forms with a single smartsheet. Each one will capture slightly different details. The forms are sort of like a helpdesk queue, where the users can have different requests, but ultimately all the work goes to the one helpdesk team, and the work is all 'queued' into the smartsheet, and from…
-
Update a cell in a row with current date when change is made to that row
I would like to know if I can have a cell in a row that updates with the current date when anything in that row is changed - kind of a "last time updated" cell. It will allow me to track stale rows. Thank you.
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.