-
Repeat cell until Value of 0 occurs again
Good morning, Looking for a formula to do the following: I would like to return "ASSY-00572" in "Column16" for all rows up until "0" occurs again in column "level" Then I would like a formula in column "ASSY TOTAL" that sums the "EXTENDED" column for all rows that list "ASSY-00572" in "Column16"
-
More options for Time entry locking in Resource Management
Currently there 3 Time Entry locking possibilities in Resource Management to choose from: 1. Do not lock time for a project 2. Lock all time entries for a project 3. Lock time entries for this project that are older than xx number of calendar days. Idea: enhance the Time Entry locking states by introducing additional…
-
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
I have paid upgrading plan from Pro to Business, but the account still in Pro Plan, how to solve it?
Hi everyone, I need help, I have paid upgrading plan from Pro to Business, and i also received the payment invoice on my email that said that i have paid for business plan (screenshot below). But, my account still in Pro Plan (screenshot below), then i still cant use grouping at the report, etc. is there a wrong way? Does…
-
How to keep a running tally?
Hello! I am trying to figure out how to create a formula to keep track of the Annual Funding Remaining for employees. As you can see with the #CIRCULAR REFERENCE and #BLOCKED I am not having any luck. Can someone assist me? TIA!
-
Date Formula: Calculate the number of days in a specific month between two dates
I'm working on a program tracker that includes revenue forecasting in each month. Project durations can range from one week to six months or more and I want the revenue to be forecasted evenly over the duration of the project. A date formula that calculates the number of days in a specific month between two dates would be…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
Filtering on dashboards?
I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issues, columns are details of these. I want to collate all this into the dashboard used…