-
How to allocate estimated work hours evenly across the duration of days
Hello, I am using Smartsheet for my Project Plan, and we are wanted to assign estimated hours to each task on the plan so that we can see if Resources are over-allocated in any given date range. I only have access to the legacy resource system, so I am hoping there is a way to do this with a formula. I have columns for the…
-
Can I make an IF reference in another sheet and then Index / Match?
Hi! I'm trying to make an IF formula that will look to see if a specific type of equipment is ordered, and if the PO has been issued, then move the checkbox to another sheet with Index / Match. Here's a simpler one without the IF... =IFERROR(INDEX({2024 GC and Contractor Sheet - Bids Range 1}, MATCH([WBS@row], {2024 GC and…
-
Formulas not updating when new data is added to underlying sheet
When new data is added or updated to the underlying sheet, the formulas are not recalculating. I run an upload workflow each morning and want the metrics sheet below to recalculate based on the updated report I attach. I have to manually re-enter the formula to get an updated metric. The counts, averages and formulas using…
-
How can I fill in a field with a name if my Location column is a specific city?
I am attempting to autofill data into a field (person's name/contact) if the city is the one they administer. I am receiving an incorrect arguement statement error. Here is what I have so far. =IF(CONTAINS("Milwaukee", Location@row, "Michelle"), IF(CONTAINS("Appleton", Location@row, "Stephanie"), IF(CONTAINS("Madison",…
-
Index/match or vlookup question
Hello , I try to find any solution for the following problem without any success. I hope somebody can guide me how to do it. I try to do some index match or vlookup but the tricky point that in my lookup array i have many contacts . Smartsheet A So I try to find within this contacts one exact match email address but from…
-
Looks & format of automated emails
Hello, I would like to use automated emails & reminders for client-facing communication. But the amount of irrelevant information enclosed is a problem. Are there currently solutions to any of these? 1- Unnecessary header that has a Log In button next to it which confuses external contacts who do "NOT" need to get into the…
-
How do I calculate the average time a representative takes to resolve a call per month?
I have created a weekly intake form that managers complete documenting how many calls their employee handled as well as the average length they were on the calls. I am creating a roll-up report where I need to calculate the monthly average length of time it took each employee to handle the call. This screenshot show how…
-
Using countif to select an option from a column
I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options. For example, in Column B, I have following look up values - Role 1, Role 2, Role 3, etc, but some rows have two or more roles - so in one row, it will say role 1, role 3. In another…
-
Vacation Tracker - half day entry requirement
Hi everyone, I found a great youtube video that helped me build a vacation tracker for my business. Only problem is the tracker covers only full day vacation requests. Could any of our great experts help me to amend the below formula to incorporate a half day vacation request? I guess I would need to add a column into the…
-
Task Health: formula dependents on Creation Date
Hello there, I need to automate the Task Health column basing on the following criteria: Blue: creation date is in the last 3 months Green: creation date is between the last 3 and 6 months Yellow: creation date is between the last 6 and 9 months Red: creation date is more than 9 months old Thanks for your help