-
IFERROR and OR
I have these two formulas in different columns: =IFERROR(INDEX({Frame ECN Updates Range 2}, MATCH([ECN / PLR / FF / CEG]@row, {Frame ECN Updates Range 1}, 0)), "") =(IFERROR(INDEX({Frame Feedback Updates Range 1}, MATCH([ECN / PLR / FF / CEG]@row, {Frame Feedback Updates Range 3}, 0)), "")) Individually, they each output…
-
Move row to another sheet not working
Hi all, has anyone else experienced issues when moving rows to another sheet? I've got two colleagues, one of whom is actually owner of both - original sheet and destination sheet. When they try to move the row from one sheet to another, it just doesn't work. I mean, it does, as the row appears in the destination sheet,…
-
Index Match Help
Hi! any help on why this formula is not working? =INDEX({Operations BOB LON H}, MATCH({Operations BOB Range 4}@row, {Operations BOB Project Code}, 0)) this is a similar formula that we have and it is working: =INDEX({Ref. BOB Range 1}, MATCH([Project Code]@row, {Ref Project Code}, 0)) they appear the same to me, what am I…
-
Index Match Formula Unparsable to Link Cells
We've been trying to link cells across sheets using variations of =INDEX({Other Sheet Column A}, [Row #]@row) and keep getting "UNPARSABLE." Since it is coming from a live form, too, cell linking won't work since that only pulls data that is already there. Any help??
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
Filters from template is not carrying over to new sheet for different user
I created a project sheet template and added filters to it. I allowed filters to be inherited by checking the box. When I create a sheet from the template it carries over the filter but when another person does the same thing it creates the sheet but does not carry over the filters.
-
Remove vertical whitespace in calendar views
We need a way to remove the vertical whitespace in the Month view of the Smartsheet 'standard' Calendar view and the Calendar App view. In the screen caps below, the red arrows show the whitespace I want to remove. The whitespace in the Calendar App view is more of an issue because the Month view in the app, due to all the…
-
Calendar App Spacing in a Date's Cell
Hi, I don't understand why at times when I add an item to the Calendar App it appears at the top of the day's cell and at other times it's not. When adding an item, I want it to be at the top of the date's cell. Is there a way to accomplish this? Thanks, Karen
-
Timeline View Task Order
Is there any way to control the order of the tasks within the new timeline view? Ideally, I'd like the tasks in timeline view to list in the same order as the gantt view.
-
Dashboards Randomly Displaying Blank Reports
I have encountered peculiar behavior with my dashboards over the past month. My reports are randomly displaying as blank. When I refresh the page, it's a hit or miss on which reports display. I have to keep refreshing until the report I want to see finally displays its data. Recent changes: I've added a substantial number…
