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
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…
Change Flag Color if Due Date is Greater than today
Hello everyone Very new in smarsheet and I have this problem I have basically a due date column and would want another column (flag field or RYG) to turn red once the due date is > today's date. I have been getting #UNPARSEABLE errors everytime =IF(AND([End Date]2 <= TODAY(), [End Date]2 >= TODAY(), RED) Please help.
Moving Cards In Kanban Is Not Updating Grid
Hi guys, I have just started working with the Agile template and I have noticed that if I move a card from say Backlog to Sprint 1 in Kanban view, it does not update the change in grid view. Is this normal behaviour?
checking off multiple boxes in a column
Hi All, I have a column using checkboxes. I'd like to filter my rows (say by name) and after completing an action (email globally to the selected individuals) check off all boxs in that column.
New sheet based on filter?
I created a filter which only shows the launch dates. I'm trying to export these dates to iCal but whenever I do the filter is not applied within iCal and it includes every subtask. I figure a work around would be to make a new sheet with only the filtered launch dates and export that to iCal, however I can't figure out…
SIGHTS - WOWZA!!!
My workplace just moved up to Enterprise, and I'm loving what I'm learning about Sights! Finally, a place to share information without having to share the underlying sheets. Beautiful work, Smartsheet!