-
Help with Index & ROW
Hi, I have a sheet with the Master List of projects, which includes all Fiscal years. This sheet contains Project Year, Location, Start and End Dates, etc… Major metadata associated with the project. I have another sheet, where I would like to get more granular and tailored for various functions such as Permit Tracking,…
-
How to have each subsequent value that matches a criterion appear in its own cell in a column?
I'm trying to pull change order numbers that are assigned to one specific person in a source sheet appear as separate entries in one column in another sheet. I've gotten it to manually work with this formula: =INDEX(COLLECT({CO Number}, {Assigned PM}, "PM Name"), 1) But I have to manually adjust the number at the formula…
-
Counting Error
Hello! I made this awesome spreadsheet to count the hotel rooms per night to give to a hotel but when I go to summarize the column to count the totals I am getting an error. I think its because if a cell is blank for some folks the formula returns "invalid operation" which in turn effects counting the TOTAL cells to get…
-
Pulling Data from One Sheet to Another
Hi This is a really simple question - I want to pull the answer from one sheet with a number in one exact cell to another sheet so I can reference that number and compare. Seems really simple but I cant figure it out. I think its v look up or index/match but they seem to want me to look for a range, this isnt a range this…
-
How can I get around the 500 cell link pasting limit?
I keep running into the 500 cell link limit which is rather frustrating. This happens when I use "Link from cell in other sheet" menu option. I'm trying to duplicate a sheet so I have the latest information. I can do it without the cell link, but I would run into the same issue. It's frustrating because in the Link from…
-
IF and TODAY Formula
I created the below formula, which works. However I only want it to show either Active or Expired when there is a date in the 'Approval Expiry Date' column. =IF(TODAY() > [Approval Expiry Date]@row , "Expired", "Active") However the formula, that has been applied to the column, is showing 'Expired' for all cells where…
-
HAS vs CONTAINS
This discussion was created from comments split from: How to detect multiple dropdown values in a contains function?.
-
Rotating Assignee on weekly basis
I’m building a Smartsheet to rotate 30 assignees on a weekly schedule, with each task spanning one week. The formula I created is returning a ‘#UNPARSEABLE’ error. Could anybody advise on how to correct it or recommend an alternative formula that supports this rotation? Any visuals appreciated as well.
-
Total Project Count FY2025
Hello, I am looking to count all projects that have "gone-live" FY2025. In my grid, there is a column titled "go-live" that lists the date a project went live. Is there a formula that can calculate FY?
-
Index / Match
Looking for some guidance. Goal: If "KPI Availability %" @ row is equal to or greater than "Annual Score % Availability" row 10 then it will look at the "Previous Contract Year Event" @ row and match it with the column header 0 , 2,3,4,5,6,7,8 (individual columns). Then it will look down the matched column where it matched…