Our wifi is VERY SLOW today. I'm getting 20 Megabits down, but only .22 Mbps Upload speed. (NOT smartsheet's fault) When I am in a sheet that contains sheet references to another sheet, it APPEARS tha…
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments w…
I need help creating a formula that I thought would be easy but is turning out to kick my be-hind, and three different Ai’s aren’t able to give me a solution either. Formula Objective: Find the Report…
I have an intake form setup in one sheet and in another sheet I have a bunch of formulas to format the data from the form into a csv that can be used to upload the information into Jira. I have everyt…
I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would…
Scenario: I have a Project A Plan sheet that has a field for Bill Rate and Role. This bill rate value is pulled in from a Client A Rate sheet via vlookup based on the value in the Role column on the p…
Hello, I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return…
I have a grid sheet full of contracts: each row is a contract. Each row has a START DATE and END DATE along with other details about the contract. I was tasked with creating a dashboard to represent t…
Hi there, I'm trying to build a summary sheet with formulas that COUNTIF cells in a column on another sheet CONTAIN a specific value (this column is multiselect dropdown). I've come up with things lik…
When creating a formula you're given the option to "Reference Another Sheet". I love this feature but it needs improvement because it ONLY gives you the option to create a new reference. Yes, you can …