-
AUTOMATE PROGRESS BAR BASED ON MULTIPLE CONDITIONS
Hello, I am trying to automate my progress bar, basing it's progress on multiple conditions. I have 10 columns I would like the progress bar to consider. Example below of how i would like it to work: If Cost 1 AND Hours 1 IS NOT Empty then progress = 25% If Parts AND Survey AND time IS NOT Empty then progress = 50% If…
-
Maximum cross-sheet references
Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck. Regards Steve
-
Rolling Fiscal/Quarterly Counts?
How would I go about populating the number of something happening within a certain Quarter or Fiscal Year? In this instance, I want to count the number of Cross-Dock orders that happened in the last quarter, but then also for the entire fiscal year. Another example of how I'm trying to use this is that I'm trying to gather…
-
Formula Error
Hi I have the following formula that should look at the number of projects in a programme RAG statuses and return back a Red if there is 1 or more project with a Red RAG, return a yellow if there is 1 or more projects with a yellow RAG, otherwise return "Green". =IF(COUNTIFS({Project to Programme Summary | Project Status},…
-
Delete or Modify Cross Sheet References in Smartsheet Gov
Smartsheet Gov doesn't offer the same handy-dandy Sheet Reference Manager as the commercial version (don't know why) that allows you to delete, etc. Is there a good, easy way to do this in Smartsheet Gov?
-
Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample. thank you!
-
Auto fill column with value from first cell in another column
I have an application where I use a header row to collect higher level project information, like overall project status, project start and end dates (as opposed to task start and end dates), etc. I copy rows from individual project plans to an "all projects" sheet from which we do some PowerBI reporting. I need a column…
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
INDEX (Match) Formula with contact columns
Hello, I am using an INDEX(MATCH) formula referencing 2 contact columns and it works great. However, when I try to convert to Column Fx it will not let me. Can we not change contact columns into formula columns? Or is the fact I am referencing contact columns in my formula a problem? I am not referencing partial ranges.…
-
Show tasks completed in calendar week?
Is there a way to count the number of tasks completed in a calendar week, Sunday-Saturday? I have a metric that shows the number of items completed in the last 7 days (>TODAY(-7)) and I've been asked if the metric can show items completed in the calendar last week, meaning Sunday to Saturday, rather than a rolling last 7…