-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -…
-
Solved: Subtracting time using formulas
Published Time of Day Conversion and Calculation sheet https://app.smartsheet.com/b/publish?EQBCT=6d765f7f8a864676b3b5d5f8fd866bf1 Original "Subtracting time using formulas" thread https://community.smartsheet.com/discussion/3795/subtracting-time-using-formulas @Shawn Roberts @J. Craig Williams I searched for "Subtracting…
-
COUNTIFS in a Date Range
I'm attempting to count how many times a sales rep's name appears in a column and the deal they're working on will be closed within a date range. I'm using a countifs statement with an AND for the criteria on the second range. I receive an INVALID OPERATION result when I use AND, but if I only look for either greater than…
-
Smartsheet dashboard view
Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
-
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
-
Need help creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. -- If columns "Reviewer Assigned" and "Approver Assigned" are not blank, I want the status to automatically change to "In progress." --…
-
Unparseable???
I am trying to figure out why my formula keeps saying #UNPARSEABLE I am trying to take the first four digits of a project number and join it with 2 digits that are the suffix to create a new project number. Please help! Here is the formula: =JOIN(MID([Project Number]1,1,4):[Project Number Suffix]@row)
-
If Formula with Dropdown conditions
I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation. Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are. If the 3 that are entered below are true it should enter the value…
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Need assistance creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. If Columns A, B, and C are blank, I want the status to automatically change to "Not started." If Columns A or B are not blank, I want…