-
Sumifs with 2 conditions in same column
I am having trouble creating a formula with 2 conditions. I currently have formulas in a Spend summary sheet that only have one condition but I need to add a 2nd condition. Here is what I have for 1 condition: =SUMIFS({Team DD - Budget - FY19-FY20- Amount}, {Team DD - Budget - FY19-FY20- Requester Team}, "Computing", {Team…
-
Do Not Apply Formula IF Field Is Blank
I am trying to calculate a variance by subtracting two columns but only if one of them is not blank. I'm having trouble getting the ISBLANK condition to work. My current formula is =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank. Any suggestions would be very much…
-
Sumifs with 2 conditions from same column
I am having trouble creating a formula with 2 conditions. I currently have formulas in a Spend summary sheet that only have one condition but I need to add a 2nd condition. Here is what I have for 1 condition: =SUMIFS({Team DD - Budget - FY19-FY20- Amount}, {Team DD - Budget - FY19-FY20- Requester Team}, "Computing", {Team…
-
Doing things first time right with data validation
In a productive organization, the most efficient method for cutting waste is to attack anything and everything that is not done right the first time. The only drawback to SmartSheet is its ability to manage "data validation" like excel does. Even with column properties set as Date, users can still write stories "text…
-
Need to transfer file ownership - Smartsheet won't let me!
Hello, I created a draft version of a workspace, now I need to transfer it to a licensed user and I get: "You have exceeded the maximum number of emails that your account can send" How can I get this fixed???? Thanks Karen
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Invoice approvals after form submitted
Hello! I am trying to set up a process where employees at my company fill out a form, attach an invoice and then I route for approval from my sheet. I need to figure out some sort of way to save both the invoice that was attached along with a copy of the approval that I have being emailed to me. In accounting I need to…
-
Data derived from mulitple criteria
Hello Smartsheet Friends, I have a single text box that I'd like to do some data analysis on, and wondering if there is a way. My text box is similar to the below "Product, Engineering, IT, Supply Chain, etc......." I want to pull all of the instances of "Supply Chain" and do a sumif. Aka total number of submissions for…
-
Charts with no data
I have a dashboard that I update weekly to show any applications that were processed through our office. Sometimes, there are weeks where we don't have any applications processed, so I don't have any data for the week. Is there a way to customized the error message in the chart? I've included a screenshot. I just want it…