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.
Discussion List
Combining IF/IF AND Statements
Hello! I cannot seem to figure out how to put together two working IF and IF(AND...) statements. Thank you for any direction on how to accomplish. Sandy If I put "IF(AND..." in front of all the IF statements, only my first two statements work. The rest are ignored. If I remove the "(AND..." from only the first two…
Alerts & Actions: Send a notification when a comment is added or updated
Does anybody else no longer see the option on the dropdown list to "Send a notification when a comment is added or updated"? (see red circle in image attached) I could clearly set this notification up in the past. (see blue circle in the image attached. Thanks!
User Changes Report
Is there a way to set up one report that shows all changes the user has made throughout any/all spreadsheets in smartsheet on a reoccurring basis (daily or weekly) ? *It would be helpful if the report showed the actual line item changes and not just the sheet link with username, date and time.
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…
Automate RYGB based on Follow-up Date by Week
Community: I have tried but cannot figure out how to make this formula work. Probably something very simple, and I am overthinking. Any guidance would be much appreciated. Thank you, Sandy Scenario: Regardless of the day of the week I open my sheet: If [Follow-up date]1 is between M - F of the current week, RYGB symbol =…
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…
Interactive Forms
I would like to create a form to collect a variety of information from users. For example, we want to record publications, presentations, and proposals that a faculty member has done in the past month. However, I'd like to keep the form short. If a faculty member has had 2 publications, but 0 presentations and 0 proposals,…
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!
