-
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…
-
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?
-
Referring to a Previous Day
Can someone please assist in helping with a formula that will simply just refer to a value from a previous date? Example: Two Rows by two Columns. The top row has a date of 4/3/22 and in the Value Column it has 5. In the bottom row the date is 4/4/22 and in the Value Column it has a 3. If I wanted to add the two values…
-
Issue with #INVALID REF in formula
Hello, I am trying to create a calculation that will then be used for a metric widget on my dashboard. I want to be able to have metrics for different groups of projects by state. My goals is for the formula to only count projects that have "P2P(Department)" in the Department column of my portfolio metadata sheet. I have…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
Case sensitive COUNTIF
I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that define unique IDs, and COUNTIF unfortunately, is case insensitive, so it is marking…
-
I am trying to count how many dates have a specific YEAR in a cell for a given row...
=COUNTIF([Date of first absence]:[Date of first absence], YEAR(@cell) = 2021) It keeps giving me #INVALID DATA TYPE
-
Help With Index Match (#Invalid value)
I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look like. ^ This is the other sheet with the look up table. ^ This is the Formula I have used. ^ ^ For the formula, Red is the…
-
IF condition is true, copy a value into another column
I have a sheet where multiple people have to approve an item before it is 'approved'. I am needing to copy a cell from the Cost column into the pending, approved, or rejected column based on the current status. So if the P/R/A column equals "P" I need the $ in the cost column to populate in the Pending Cost Column, etc.…