-
Formula to find todays production
Hello Smartsheet Experts! Im hoping someone can help out here... :) We are attempting to see if we can get a formula that will give us todays production based on the percent complete? i.e. the project is worth $100 and on day we complete 20% so the value would be $20. Day 2 we progressed to 50% so our value for the days…
-
At months on to a date
I am looking to add months onto a date based on what is shown in the column highlighted in the screen shot. It is simple in excel using "Edate" but I can not seem to get it working in Smartsheet Thanks in advance
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…
-
How do I copy a formula and update a cell reference
I'm an excel user, but new to Smartsheet so I'm still trying to figure out how it works. Please see screenshot attached for reference - I have a formula in the "Yes_2" cell (circled in red). That formula references another sheet "CSF Questionnaire Range 7" (highlighted yellow). Next, I copied the formula and pasted it in…
-
Self-updating report based on sheets in folder
Hi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks…
-
IF statement returns formula statement, not value of formula
I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being…
-
Nested CountIf function
Hi there. Is there a such thing as a nested countif function?? I'm aware of how to use the countif in smartsheet... =COUNTIF({ Test Sheet Range 3}, "Approved") Suppose I want to count records with more than 1 criterion? Status = Approved Stage = Stage 1 How would I craft that out? Is it a nested CountIF function?? Thanks,…
-
Formula
I want to include a column, On Hold, a checkbox (0,1). If it's checked, I want the State to be "On Hold", with another formula that enters State depending on two other cells - Status (RYGB) and % Column. Unchecked and it should follow the rest of the formula. How do I combine them? =IF([On Hold]@row = 1, "On Hold")…
-
No of CVs sent by role and month
Hi all I’m trying to create a formula to show the number of CVs sent by month and role So number of CVs for Delivery Managers for October (pic below) is 18 but how I do I get this from a formula? I can get the number of CVs for all of October using a simple =SUMIF formula but when I trying adding in the role, it breaks!…
-
Current Year Month in a count formula
I'm having problems finding the right syntax to count the number of records for the current year month. My sheet may have records from several past years but I just need to count the number of records by month for JUST for the current year - even if I must update the formula each January - that's ok. My basic formula for…