-
Conditional Formatting Based on Min & Max Columns
I have a sheet that shows the stock of all promotional items across several locations and I'm trying to set up conditional formatting to highlight the cell if it's less than or equal to the min amount. I can do this manually for every row but wondering if there's a way to do this similar to how excel & Google sheets have…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
How do I check an entire column for a particular value and only display the lowest example of it?
The question title is kind of confusing, so here's what I'm looking to find out. I'm making a Project Plan sheet, and want to have a place that updates the estimated completion date based on how the project has progressed thus far. There are more columns in my sheet, but my question is only related to the ones in the…
-
Receiving an Error Code when Creating Chart
Hi everyone! I created a metrics table to count how many "Critical, Major, Lesser" observations I have per a CRO Management group for a specific timeframe (quarterly). The formula I used in the metrics sheet is as follows: =SUM(COLLECT({Audit Schedule Range 6}, {Audit Schedule Range 2}, "CRO Blood and Marrow Transplant",…
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
COUNTIFS
Hi, I have this formula below but its picking up everything that contains small fixes. We have small fixes, small fixes delivered and small fixes closed but I would only like to find results that are small fixes only. Can you help? Here is the formula I have =COUNTIFS({TL}, FIND(Metric@row , @cell ) > 0, {IS},…
-
Integration between Smartsheet, Zapier, and ChatGPT (Agent Mode)
I’m exploring ways to automate vendor data validation using Smartsheet integrated with AI tools. Is there any built-in AI or agent mode within Smartsheet that can handle data validation and automation directly? Or do I need to rely on external integrations such as Zapier or ChatGPT 5 (agent mode) to achieve this…
-
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
-
INDEX COLLECT MIN (again)
Had a follow up question to my previous question located here. — I was using the original sheets, which I fixed with the solution from that thread, as a template. Today, I copied them over to essentially create the same system for a different LOB. I checked the box that updated all formulas to the new references. Now, in…
-
Sort a Join/Collect formula?
In a sheet, I have a helper column that concatenates the date and budget columns. Then a field in the sheet summary that uses JOIN COLLECT to list that data. Is there a way that I can have that listed data be sorted by date? In case this helps, here are some screen shots - Helper column Output of the Join - collect formula…