=INDEX([Job Name]1:[Job Name]15, SMALL(IF([Job Number]22=[Job Number]1:[Job Number]15, ROW([Job Number]1:[Job Number]15)-ROW([Job Number]1)+1), ROW(1:1)))
I'm not sure I follow. What exactly are you trying to accomplish? Can you provide more details?
I have created a SmartSheet Travel and Resource calendar where my organization logs in their travel dates, to which operational sites we visit, etc. Each team in the organization has its own sheet, but a dashboard consolidates the information. How can I build a table in the dashboard, that dynamically updates, to show who…
I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works: =SUMIFS({Expense Collector Range 4},…
Hi everyone, I’m rebuilding an Operational Status formula that references another sheet for quarter-end deadlines. The formula works logically, but Smartsheet keeps returning #UNPARSEABLE. Here’s the current version (I’ve confirmed all range names and column types are correct): =IF( AND( OR([Step 1: CQ LAUNCH Required (Yes…