-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
-
Automated update request
Hi, I have a task that need to monitor status of monthly building reports to clients. The process is like as following: 1. Form department will generate building reports (each person in Form department has their own portfolio). 2. they will fill in the form on SmartSheet to input when they create the building reports and…
-
Need help with date range overlap formula
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the following formula works great: =SUMPRODUCT((D2<enddate)*(E2>=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…
-
Importing Excel Formula into SmartSheet
I imported my URL builder in Excel with formulas so that my marketing team can all use it. The formula is "#UNPARSEABLE" This is what I had in Excel: =D3&"?RecType="&E3&"&utm_medium="&F3&"&utm_source="&G3&"&utm_campaign="&H3&"&utm_content="&I3 Can someone help? I did substtitue & with + but it isn't delivering my long-tail…
-
SUMIFS Formula
We currently have a SUMIF formula that sums up a Annualized Estimate for a specific Ministry. The Sheet with this data uses a form to populate additional rows. The currently working formula is =SUMIF(Ministry:Ministry, [Ministry Name - Annualized Estimate], [Annualized Estimate]:[Annualized Estimate]) We wanted to break…
-
Help
I inserted a row at the bottom of Product Development and the End Date did not change at the top level of the cycle. My cycle ends on 12/27/17 and the End Date shows 11/27/17. I tried to edit formula but cannot. Example file attached
-
SUMIF children when date from another column is older than TODAY()
I'm trying to get the numeric sum of the children of a parent when the date from another column is older than today. I get #UNPARSEABLE when I try. This is what I have:
-
If cell fill is a given hex color code, then return value
How can I identify the hex color code for the cell fill options? I want to write an IF statement to return value of 1 if the hex color code is the darkest blue (as an example). A little background.... reporting 6 status stages so the symbols aren't an option. Thanks in advance for your help!
