-
If & AND equals checkbox
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box Thank you in advance
-
Locked columns
When you lock a column, is the person that created the form the only person that will be able to update that column? I have a column that I want one of the people that I will share the report with to be able to edit the column.
-
#INVALID DATA TYPE
Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is…
-
Bug: Report formatting inconsistent
I have conditional formatting in the sheet based off of this [Hrs Over SLA] column. The conditional formatting is correct in the sheet but incorrect in the reports for only some rows (see circled for example, where -67 is highlighted on some rows but not in others) How does one resolve this issue?
-
Report ignoring "is blank" parameter
Hi all, We have a report that is suddenly not functioning properly. The report pulls all projects that do not have a Start date and has been functioning without issue until this week. Two of the newest projects given dates are still showing up in the report after deleting and re-entering, refreshing the report, rebuilding…
-
Linking a drop down cell to the workflow
I have a drop down status cell on my customer sheet. I would like the info in this cell to be linked to the Workflow sheet in the status cell for each customer. I have tried to go to the Workflow status cell for a customer and link in from the customer sheet, this works and when the customer sheet status cell is changed…
-
Filtering gantt chart
Hello everyone, My goal is to filter a gantt chart so that clients only see a portion of my task list when I export a gantt chart for them. Since I'm brand new to Smartsheet, I'm hoping to run my workflow by all of you to make sure I'm on the right track. I first assemble my master list of project tasks and sub-tasks. The…
-
SUMIFS Formula Help
I want to calculate the Total Infill when the elevation is North, the floor is 2, and the L1 Infill Type - L10 Infill Type is GL-3. =SUMIFS([Total Infill]:[Total Infill], Elevation:Elevation, "North", Floor:Floor, "2", [L1 Infill Type]:[L10 Infill Type], "GL-3") This formula works perfectly if I only want to know the Total…
-
Resource Allocations based on Capacity
I am trying to figure a way to do resource allocation based on the number of projects a particular sub can handle at one time. We have 20-30 projects next year and trying to award bids based on capacity of the subcontractor. For example, one electrician maybe able to handle 3 projects at a time vs another who can only…
-
Web Form Submissions Misplaced
I've created a new basic sheet with an associated web form. New web forms entries are being placed down on row 52 and not at the top of the sheet. How can I remedy this?