-
SumIfs with multiple values from same column
I'm attempting to Sum $ based on several statuses in the Status Column, but can't figure out how to use multiple values. I successfully used the below to sum for one status, but need to add 3 more statuses "Pending Mail Merge" , "Awaiting Calculation" and "Payment Received" =SUMIFS([Amount of Bonus Owed to Company…
-
VLOOKUP not working in a specific sheet of destination
Hi all. I am trying to do a simple VLOOKUP calling to a sheet as simple as the following one, wanting to get out of the Worker the Manager in the next column Nonetheless, I am puzzled. When I open a new blank sheet and do the changes, the VLOOKUPS works perfectly, but in the following sheet, with exact same formula and…
-
Combining selected cells into one cell ignoring blanks?
Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…
-
Color code drop-down lists in calendar view
Hi all, I am new to Smartsheet and I hope you can help me with a question. This is my current sheet set up to keep track of the events organised by my team organised by country. Each country is a Parent row and child rows are the events' names. I would like to format it in such a way that if the parent row is color coded…
-
Return Text that is in a Data/Number Column that captures dates
In the table below, I have 3 columns that are text/number fields: Final Document, Target Date, Actual Date. In the Target MM/YYYY and the Actual MM/YYYY, I have a formula to pull the MM/YYYY from the Target date and Actual Date, but as you can see, there is "On Hold" and "Cancelled" text instead of a date in some of the…
-
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
-
countifs and a date that falls between two dates
Please help! I have two formulas that I am struggling with. I am trying to count how many tasks have been completed/closed within the past fortnight. I came up with the following formula but it gives me the 'invalid operation' error. What am I doing wrong? Formula=COUNTIFS({LV_ BLD CONST QUERY REGISTER _status}, "closed",…
-
Need someone's logical brain on a formula
Hi all, I need help fixing this formula: =COUNTIFS({TGN Bluesheet Tracking List Range 4}, =DATE(2023, 6, 20), {TGN Content Range 2}, =AND("Facebook" "Instagram" "Threads" "X" "YouTube")). I'm trying to pull the number of a specific dropdown list from a specific date. Any ideas on the best formula?
-
Extract text from a file string
Hello! Simple question (I hope). I have a list of document locations - that look like this: _Central Documents/Training/Investigators/Rhodes, Meredith/CV I would like to parse 'Investigators' into a staff role column, 'Rhodes, Meredith' into a contact column, and 'CV' into a document type column. What is the basic formula…
-
Using the holiday parameter in workday function
=IF(Runs@row = "Daily", WORKDAY([Completed Date]@row, 1, {Holidays Range 1}), IF(Runs@row = "weekly", WORKDAY([Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2), 5, {Holidays Range 1}), IF(Runs@row = "Monthly", WORKDAY(DATE(YEAR([Completed Date]@row), MONTH([Completed Date]@row) + 1, 1) - 1, 1, {Holidays Range…
