-
I am wondering if I can chart revenue by month in the below example?
The chart is pulling from a cell that for instance is a $1M dollar project over multiple months however I can only figure out how to display the revenue in the 1 month. =SUMIFS({Pipeline Overview Data Range 2}, {Pipeline Overview Data Range 5}, >=[Start Date]19, {Pipeline Overview Data Range 5}, <[End Date]19, {Pipeline…
-
Counting a row only if it's a child row and has been modified in the last 30 days
I'm trying to create a formula to only count rows that are child rows (was trying to do this using the Counter row being <1) and have been modified in the last 30 days. I was able to get the modified in the last 30 days part to work on its own, but can't get them to work together. Here's where I'm at now - any suggestions?…
-
Problem with a COUNTIFS formula
Hello I am having problems with this formula =COUNTIFS(Date:Date, AND(IFERROR(YEAR(@cell), 0) = 2021, Reviewer:Reviewer, "IP")) I get a #INVALID DATA TYPE Error. Not sure what I am doing wrong. Thank you for your help.
-
Populate a cells value with the previous value of another cell
I am looking to have a rolling history of values. I want the cell to the right to have the previous value of the cell to the left. In other words, if I update the left cell, I want the left cells old value to move over the right cell? I cant seem to find a way to do this. Thanks
-
SUMIF Formula Not Working for column with #'s but working with text..
My sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column, essentially 64,345.03 but it's returning 0 but when I sum it on the description column…
-
IF Lookup to Fill Cell With Data from Another Sheet
I'm trying come up with a formula that will look at a cell A in sheet A, reference cell A in sheet B and if they match copy data from cell B on sheet B to cell B on sheet A. I've the formula below in excel to copy of tab to tab and this didn't work with Smarsheet. =IF([Inventory Number]@row>0,lookup(2,1/{Computer Inventory…
-
COUNTIF and CONTAIN Formula Help
Hello, I'm creating a view for the dashboard that counts the number of open risks, issues, and decisions from a project dealing with multiple platforms (A, B, C, D). I would love some assistance with correcting my formula. I'm referencing another sheet (Risk & Issue Log) that has the following range columns: Platform (A,…
-
I WANT TO CREATE A "REQUEST FOR PRICING"
THIS WILL GO OUT TO 5 VENDORS SIMULTANEOUSLY. THEN I NEED TO BE ABLE TO RECORD THIER RESPONSES INDIVIDUALY, BUT ON THE SAME SHEET WOULD BE GREAT. I WILL NEED TO SEND OUT MULTIPLE REQUESTS FOR DIFFERENT JOBS WITHOUT HAVING TO DELETE EVERYTHING AND START NEW EVERY TIME I MAKE A REQUEST FOR A DIFFERENT JOB
-
Conditional Formatting using a custom formula?
Hi there, So I'm trying to set up conditional formatting to visually alert us if 3 days go by and we haven't followed up with someone. My idea is to make an "Estimate Sent" cell which records the date we sent an estimate and turn it red if we haven't checked the "Estimate Approved" column after 3 days go by from the date…
-
INDEX(COLLECT #INVALID VALUE error
Hi! I'm trying to solve a formula issue. I'm trying to pull text (Title) from a source sheet based on 2 criteria: Slot and Score. The slot needs to equal 1.1, and the score needs to match adscore@row. Here's the formula I created: I am getting a #INVALID VALUE error message. Other background information: {Title}, {Slot},…