-
Formula to Summarize spending each week to display in a Dashboard
Hello, I have a large sheet that we use for procurement for our company. Employees use a form to requisition items, and then when I place the order for them I input the date ordered into a column. Another column tracks the cost of each order. I would like to have a formula that uses the "Ordered Date" column to add up the…
-
IF Formula for Today's Date between Two Dates
I'm trying to create a formula that is only triggered when today's date is between two dates. Otherwise, I want it to be blank. I want the dates to be in the cells and not just in the formula. I use this year over year and it will be a lot faster to change them for next year. I get Invalid Operation when I use the dates in…
-
Link % completion and Status fields
We have 2 columns. 1) % completion 2) Status (not started, in progress, completed, significant delay, etc). We would like that every time we move % Completion from 0 to any number up to 100, Status gets automatically updated to "in progress". And when % completion hits 100%, then Status is "Completed" We will still want to…
-
COUNTIF and CONTAINS in a formula.
Hello! I am trying to count the number of times where a specific phrase is. For example, I have XX - YYYYY as my specific phrase; but some times there might be an XX - YYYYY - ZZZZ or even UUU - XX - YYYYY - ZZZZ. Is there anyway to count the amount of times that "XX - YYYYY" exists?
-
Ranking by score
Hello, I have a sheet that contains people and scores (1-100) based on their performance. I want to create a table to show the top 10 and the bottom 10 people based on their score. Any ideas on how to do that? Regards,
-
Formula Needed!
Hi! I am needing a formula that will count the number of occurrences month to date of a specific data point. I am working on a dashboard for complaints and I am wanting to have a formula on my master sheet that will calculate the number of regulatory complaints we have received month to date that will update with new…
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
Index and collect most recent text and where not blank based on Max Modified date?
I'm using the following formula to collect the most recent comment from children cells. We are having an issue when a user adds a comment and then deletes it and/or types a new comment within the same cell within the same minute. When this happens, the parent retains the blank cell "comment" or doesn't recognize the new…
-
How to search , and match the couple data from 2 sheets and result show on 3rd sheet
Dear All, I'd like to calculate Total stop time of each machines per day. I have tried to find out the solution for search and match the couple data from 2 sheets and result of the couple data show on the 3rd sheet but I am failed. Anyone please help me, how to match and pick up the correct data as example ? Thank you.
