Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for October 2017
Discussion List
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
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!
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…
How to count the number of rows of the children?
Hi guys, I spent a whole day searching the forum but didn't find any relevant answer. I need to know how many children rows a parent have to do some calculation. So it's not about the content/number/text in any cell of the children rows, but the NUMBER OF CHILDREN ROWS(no matter what's inside them, even if they are blank).…
Outlook Integration - Updating Comments sent out as emails
I currently use the Smartsheet Add-In for Outlook for forward relevant emails to existing (or creating new) tasks and this works well in tracking needed information. I currently use Smartsheet individually and not as part of a team or group. I am wondering if there is a way I can add a comment to a Smartsheet task/row…
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…
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:
Formula for RYG based on % complete
Trying to get RYG symbols for % completed on tasks. I am getting #UNPARSEABLE =IF([% Complete]4 = "100%", "Green", IF([% Complete]4 = "50%", "Yellow", IF([% Completed]4 = "0%", "Red", " "))) Can anyone please help?
Alternative to VLOOKUP in SmartSheet?
Is there a 'bolt-on' in Smartsheet that does the same thing as VLOOKUP?
SUMIF with OR condition
Hi. We have a calculation that will total various costs based on a manager. It works fine if we only need to include costs for a single manager. However, it doesn't work if we want it to total costs that might be related to more than one manager. We're using an OR condition when checking for the manager. Can you please…
