-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
Formula to calculate start date, from end date
Hi SS community, I am trying to write a formula to provide a date, 45 days prior to the start date. Ie. = [Start Date]1 - 45days Appreciate the help.
-
=SUMIF Help please:
Hi Team, Formula not working…(#UNPARSEABLE) =SUMIFS[Value of Job],2 [Sold Date:]2,>DATE(2016, 12, 31),[Sold Date:]2,<DATE(2017, 2, 1), [Result]2, 1 Trying to get “Current Month Sales” to calculate “Sold Date” when “Sold Date” matches the current month we are in (January) * * When February rolls over I wanted “Current Month…
-
Determine if Date is a Holiday
Does anyone have an idea of how to determine if a date is a holiday or weekend (if those are specified in the sheet) in Smartsheet via formula use only? The equivalent functionality I'm looking for is one row to have a check a box if the date column is a holiday or weekend day. I've tried a lot of "creative" workarounds,…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
Roll-up distinct selections in dropdown to parent row
Is there a way to roll-up child dropdown selections to the parent row so that the selections show only once in the parent? Example: Dropdown contains: Red, Blue, Yellow Child 1 selects Red Child 2 selects Yellow Child 3 selects Red I found where I can use JOIN(Children()), but this will display Red, Yellow, Red in the…
-
sum children
I can not get two parent rows in a column to sum or count as a total. I only get "0". I have parent row#1 that counts 4 children with ="Files: " + COUNT(CHILDREN()) and I have parent row#2 that counts 3 children with ="Files: " + COUNT(CHILDREN()) . However I am not able to total these two parents rows into a total number.…
-
Formula to highlight a cell
What would the formula be if I want a cell to be highlighted in a particular color depending on the entry in another column. Example: If column A has the word "Light" in it then column D is highlighted yellow. Thanks!
-
Automatic Column Updates?
Hi I am trying to create a formula that is set for the whole column in the sheet. What I want to happen is whenever the Status of the Harvey Ball is full, the "Done" column well create a check mark in the cell. Is this possible? If so, how? Thanks.
-
Once a field is marked to yes ignore the rest of the formula
I am trying to create a sheet where as a step is completed the steps are updated with a checkmark symbol. As a drop down comment is added in a column the formula updates the step to complete. However onece I change the drop down comment the symbol changes back to "No" or X. I would like to know if there is a why to write…
