-
How to get my numbers to correctly add up?!
Hello everyone, I am tasked with tracking budget moving forward and would like to be able to track overall budget but also budget for each POs. I would like to have the formula to add the Children's Children's (if that makes sense) and ignore the Total of the PO. This way I can have the total of the PO's in one line but…
-
Trying to Join Multiple Rows to one cell
I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to set up Shipping and Delivery notices. I am still pretty new to smartsheet and I have tried googling and watching videos on…
-
AVG formula #DIVIDE BY ZERO
Hello, community! I have a question. I'm using the "IF" formula to calculate a percentage based on the status in the "status" column. now, I'm trying to calculate the average of those rows, but I get a "#DIVIDE BY ZERO" error when I use the formula AVG. How can I resolve this?
-
Help Article updates - January 2025
Hello Community, We’ve published the following new content: Using helper columns in Smartsheet Control Center: Troubleshooting FAQ To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the end of each article.
-
Formula that will look at how many submissions there have been by group in the last 7 days
I am trying to figure out how to pull the data from a different sheet to build my roll up and dashboard. I am trying to use the following formula. The goal is to be able to show how many submissions there were last week for each group. =COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY()), ({JHA Tracker with Form…
-
Can I create headers and subheaders in a spreadsheet without there being data.
I'm very new to this. I'm trying to create headers and subheaders (lising program names) in a single spreadsheet using the indent function then color formatting the header and subheader rows. When I make a report, I don't want the headers to show errors because they are missing information. I just want the data fields to…
-
Formula to Display Top 10 Rows with Lowest Ranking
I have a sheet that captures the average rankings assigned to requests in order of priority. I need a formula to create a metric that displays the Top 10 request IDs that have the lowest average ranking (lowest ranking = highest priority). Here is an example of what I need: The metric needs to be dynamic as the top 10…
-
Help Article updates - December 2024
Hello Community, We’ve published the following new content: Smartsheet Control Center: Program reports Admin Center: Configure IdP-managed access Admin Center: Manage IdP role-based groups Prepare your IdP for IdP role-based groups Admin Center: Change a user's primary email address System Admin guide for migration to the…
-
Formula to populate parent row with children row data
I need a formula that will populate a parent row with whichever child row is NOT blank, I would want the parent row to copy the same sentence that is in the child row into the parent row. The reason I need this is because I am using the document builder sheet to create status reports so I need the parent row to pull…
-
Room Reservation System using Dashboard- Calendar, Dynamic View, Form, Report
Hello all, I have seen a number of posts on this subject but none with the most recent updates in Smartsheet. I want to create a booking system that has a root back end grid in which each desk space (70ish distinguised by Room Number and with an added filter of Floor and Direction [2nd floor, 3rd floor West, 3rd floor…