-
Help with check boxes
Hello, I am trying to figure out the formula to get a check box to auto check when two other boxes are checked. In the image attached, I'd like to link the check Boxes in line with Person 1 and Person 2 to the check box in line with President Elect. How do I do that without linking all the other lines? Thanks
-
Resource Loading across projects
Hi, I have a situation wherein a developer is working across 3 projects, with his loading being: 1. Project1 - 50% 2. Project2 - 25% 3. Project3 - 25% When i plan his task for Project1, i need to ensure that he is only 50% and accordingly the duration for the task needs to be calculated. Is there any method where i can…
-
.dwg files as attachements
I uploaded .dwg files as attachments but can't open them from Smartsheet. Anyone else using .dwg files?
-
TODAY() Formula Not Working
I am in the process of creating a sheet that shows the duration each of my machines has been on site. I am trying to us the TODAY() formula to reference the current date, but it is not working. Essentially, I am trying to use the 'Date Delivered to Site' column that I've created, and have the 'Duration on Site' column…
-
Status automated e-mails no longer?
I just noticed that I am no longer receiving the automated emails on Smartsheet status. When I try to request them again, only a dump of RSS or Atom feed is available. Has this feature been removed?
-
Formula vs Conditional Formatting
I was hoping conditional formatting could solve this but can we do IF/AND on conditional formatting? If not, what would the formula look like? If the End Date is in the Past AND % Complete is NOT 100% change End Date Font Red. Currently, I have a formula that will flag "At Risk" column if the date is in the past and %…
-
IF(OR Formula Help
What am I doing wrong? If Required Column, Rows 23-34 are "Yes" OR "No" THEN show "Yes" symbol, if NOT show "On Hold" This is the formula I'm using: =IF(OR(Required23 = "Yes", Required23 = “No", Required24 = "Yes", Required24 = "No", Required25 = "Yes", Required25 = "No", Required26 = "Yes", Required26 = "No", Required27 =…
-
If all children are not blank then enter a phrase
Hi I am having trouble writing a formula that will return the phrase "Completed" in a cell of a parent row if all the children are not blank. If there are some blank cells then it would return "Not Completed". I am trying to get the word in the parent row in the column "Opera Analysis Code", if all the children have…
-
Sights & Gantt Chart
In my report, the Row description is showing on the gantt chart as I have set-up. However, when I look at the Sight Gantt chart it is gone. Also, my project starts in March and it keeps going back to January 01 for the display. This results in a lot of blank data that is useless.
-
Estimated vs Actual Time
How does everyone accurately document their Estimated Time vs Actual Time Spent on tasks for a project? Currently, in our planning process we assign a Start Date and an End Date for each task (with allocation %, duration, and predecessors for each task) once the person assigned to the task acknowledges and begins working,…
