-
How to ignore #DIVIDE BY ZERO in SUM function?
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…
-
Sum like data when information is stored in multiple cells on the same row
Hi. Any suggestions on how to sum data when it is stored across multiple columns? Each row contains up to three values and associated dollar amounts that come in via a form. I'd like to create a list of distinct values across all rows and sum the matching dollar amounts. Any suggestions? Thank you.
-
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…