-
Stacked IF Statement Using AND and OR
I'm trying to write a formula that evaluates three columns of dates and pulls in the value of a fourth column (MWh@row) if each of the first three column's dates have already occurred in the past or will happen before the end of this year, and I'm not having any success. I keep getting an "#INCORRECT ARGUMENT" error. Can…
-
Auto-populate parent/child rows in a separate sheet?
Hello! I was wondering if there was a way to have certain column data automatically transferred to another sheet. Once that data is transferred, I would like for that transferred data to automatically populate into an existing parent row (if the account name matches). Example: Sheet 1 is a request sheet that is auto filled…
-
COUNTIF by Month in Date
I've always struggled with calculating total count by Month; i can do it for every else but when you throw in dates, it throws me right off. Essentially what i am trying to do is calculate on another sheet the amount of travel done within the month of March This is the formula i am using, but it comes back with 0…
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
-
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
-
How to create a day countdown from starting date
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
-
Elapsed days as Duration with Normal days or weeks as Lag
This combination doesn't work with current version of Smartsheet. It used to work, but now it doesn't. I raised this issue, but I was asked to have a workaround to have a dummy lag of Normal days or weeks and make this as predecessor of the Elapsed days Duration. This creates longer Activity lines and reviewing the…
-
Soumitra Dutta-How do I get started with Smartsheet?
Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m new to Smartsheet and want to get started using it effectively. Could you share your tips, recommended tutorials, or best practices for beginners? Any advice on how to set up my first sheet or manage projects would be really helpful. Regards…
-
Global Referance point
I and I think alot of others really need this, We need to be able to have a global reference point so that we can reference across multiple sheets that have that same column . at the moment we can only refence one sheet at a time per formula example: =INDEX({MACH MAT}, MATCH([Row ID]@row, {MACHROWID}, 0)) If i want to find…