-
SUMIFS with Variable Criteria
Hello all. I am having trouble find an existing answer to this in the community so I thought I would post my question. Forgive me if this has been covered. Scenario: I have 1 data sheet that is populated with many rows. Going left to right, each row has six descriptive fields. Some are single-select dropdowns and some are…
-
Permissions -- Filter Sheet but No Edit Privileges
I have collaborators that need/want to be able to filter data on a grid sheet. We need to ensure there are no editing permissions. Is there a setting that allows this? Thank you.
-
Pull Most Recent Invoice Data for An Account Using INDEX/MATCH/VLOOKUP/MAX (Or Other)
Greetings! Our team uses a Smartsheet to track monthly invoices for each client. Each invoice date is listed separately for each client (see attached). We are interested in populating in another Smartsheet the date of the last invoice. For some clients, it might be 02/28/2022, for others 12/31/2021, or other dates for…
-
Fill Month Category From a Date Time Stamp.
Hi, I am wondering if there is an IF statement that can fill the month Category ( January, February, March, April, May, June, July, August, September, October, November, and December.) From a time stamp Column (April-7-2022) and If the date is within the range of the month of April it will populate the column category with…
-
How do I import a MSProjoject into SS reflecting the benchmark details
I have a client who is heavily invested into MS Projects, his template reflects his benchmarked dates as well as the actual start and end dates, when I import the project plan it does not reflect the benchmarked dates although I can view them in the original MS Project file. How do I get all this data in, please help, at…
-
Is there a CHOOSE function? Need to calculate quarter based on date
Recently, my manager and I tried to find a formula that would calculate the FY quarter based on a "Start Date" column. We couldn't use some of the functions we saw on the community because our fiscal year starts in February. We finally found a couple of solutions that work using the IFERROR formula, but it's quite long!…
-
Box checks automatically if criteria is met - formula?
Hi! I'm trying to get a ticket issue checked as 'resolved' when somebody fills out a certain field. How do I get smartsheets to automatically check 'resolved' when "self help recommendation" column is "I have tried this and found a solution". Any help?
-
Evaluate 4 columns with an OR then a fifth column with an AND
I have four status columns which have Red, Yellow, and Green options in my list of projects. I want to count how many projects (rows) have at least one Red. Then, I have a 5th column that if checked, I want to exclude from the count. I have this logic producing a row report for a dashboard. Now I want just the metric. Any…
-
Backdate into Last Year
Trying to backdate 6 months or 180 days from a specified date. I'm able to go back 6 months without any issues, but I want to return that date for the 1st day of the month. =DATE(YEAR([1st day]@row), MONTH([1st day]@row), 1) - 180 If it backdates into last year, it doesn't go to last year and instead changes it to the…
-
Pull data from 2 sheets into one
Hi, I am trying to make a table in one sheet, with counts of items coming from 2 other sheets when they meet certain criteria. I am using COUNTIF. When entering the formula, I can only refer to sheet1. If I want to refer to sheet 2 in some of the rows, the whole column (all rows) will then be changed to the range in sheet…
