-
AND(Contains(...), Contains(...)) Functioning
Hi all! I have a question I have not been able to fully decipher with the documentation. I have been trying to identify if a certain combination of values in 2 columns appear in 2 other columns from another sheet. (Let's say I search value A in "Alphabet" column; and value 1 in "Order" column: I want to find out if the 2…
-
Is it possible to change the Source Sheet from Reference instead of individual references ?
Dear Smart Team, How can we modify the Source Sheet name from the Reference instead of modifying individual references. Scenario. I have created more than 50 References use this reference in different formulas. For Example Question and Answer. Reference "Ans 1" for Answer 1 and "Ans 2" for Answer 1 and so on, till 50th…
-
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?