-
Can I get a total of the filtered rows?
Hi Community, I've seen posts like this before, but cannot see if anything has changed in the past 4 years so hoping someone might be able to help! I'm rebuilding my team's yearly budget which contains a number of fields that would need to have filtering capabilities. With the previous program we used, we were able to get…
-
Ignore #DIVIDE BY ZERO in Sheet Summary SUM formula
I have a formula in my template Sheet Summary that I need to add the dollar amounts in the Annual Cost (Original) column. However, some of the rows will generate #DIVIDE BY ZERO. I need this formula to add only the cells that have a dollar value in them and to ignore the #DIVIDE BY ZERO. The formula I currently have in the…
-
Formula for last working day of every month after a start date
I am looking for a formula for last working day of every month after a start date called Open Enrollment@row85
-
Formula for every Wednesday
I am looking for a formula to populate a due date column of every Wednesday after a start date
-
I am trying to create a formula to calculate project ranking, but don't know where to start!
I am working for a formula to determine ranking based on some questions that people need to fill out in a form. Here are the questions they need to answer, as well as the options: Financial Resources: CapEx project or over $25k$5k - $25kLittle to no expense Internal/ External Resources: External resourcesMultiple resources…
-
Sequencing automations with no condition/trigger overlap - clearing top row after an automation
I'm hoping you can help! TL;DR in the weeds - I'm looking to use a change in the sheet to trigger an automation - but only act outside of the actual trigger TLD;DR big picture - I actually simply want to run two automations sequentially. As far as Smartsheet can tell they are entirely disconnected. (Their connection runs…
-
Shortcut for counting lots of items in multi-select column?
Hi all! I know how to do this manually but am hoping someone has a shortcut! I have a sheet with a very long dropdown list of college majors for employees who have signed up for a particular program. It's a multi-select field since many people had more than one major, and they can also type in a response if their major…
-
Linking data from multiple sheets to one master sheet - then to a dashboard
Context: I have a team of people with their own individual smartsheet trackers that each contain identical columns. I want to have the rows on those individual trackers automatically populate/update in one master tracker where I can see everyone's data at once. I have already tried reports - this doesn't work for me. The…
-
Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025
I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
-
Trying (without success) to use a contains with a Countif when referencing another sheet
When I try this statement: =COUNTIF({PM Assigned}, [PM Name]@row) I get the number 55 - which is correct. The number of cells that EQUAL that value are 55 BUT I am looking for the number of cells that contain that value (Should be 56), but I have had zero luck with all of the combinations I have tried. Any help? To state I…