-
How far can Conditional Logic go to screen? Screen does not work
I am trying to use: CONTAINS(OnePt, @cell), [OnePt]:[OnePt] Essentially I am trying to use Location - OnePt - to see if there is a record of OnePt input into a record. If I cannot use the logic, can you explain the scenario and cell in a column I can use to execute the logic? As always, Big thank you! Carey
-
COUNT IF with date and multiple criteria
I am trying to pull data from another sheet and would like it to count the criteria IF the date is less then a specific date. This is the start of the formula. When I do just the date portion it works fine, as soon as I add in the other criteria I need I get unparsable. =COUNTIFS({Date}, <=DATE(2020, 6, 30), {BDDM…
-
Adding Columns with Dates
Trying to add up two different columns- I think I got the first figured out, it would be a sum of all charge offs w/in a certain quarter this was my formula: =SUM(COUNTIFS({Credit Card Charge Offs Range 1}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2020)), (COUNTIFS({Credit Card Charge Offs Range 1},…
-
SUMIF on separate Sheet
Hi, I'm new to the community and fairly new to Smartsheet and already hit a wall and finally decided to reach out to the community for assistance! I have a sheet with one column called "Broker" with approximately 30 names and one column called "Commission". My goal is to be able to calculate on a separate sheet total…
-
Ad hoc reporting
In forms or reports is ther a way for user to enter a variable? Situation: Sheet contains thouseands of employee names and corresponding information. Do not want users directly in sheet so they need to update information via report. Is there a way a report can ask user to enter a variable such as name rather than having to…
-
Contact List using DataMesh & Concatenate
Hi, I have added 2 columns to a data sheet, one for Analyst Name and one for the Analyst Manager. I have brought in the email addresses of both of these by DataMesh. I want to be able to apply a current user filter to a certain column which would enable the Analyst and their Manager to only see the rows that are applicable…
-
Need help with RYG status formula
=IF([% Complete]@ROW<.7, "RED"), IF ([% Complete]@ROW< 1>.7, "YELLOW"), IF([% Complete]@ROW)=1, "GREEN"),""))) If below/above certain percentages, attempting to change the ball to red/yellow green
-
How can I add character count, like in the content calendar template?
I'm trying to add the function of character count in my template. It's the same feature that's used in the Content Calendar feature. What is the formula?
-
VLOOKUP on a multi-select column
Hello, Say I have a multi select column with 4 possible choices (North, South, East, West). If North and South are selected, is it possible to write a VLOOKUP to pull the first selection, and then write a second VLOOKUP to pull the second selection? In other words, is it possible to parse multi-select columns? Thank you.
-
Row numbers
Hi, I have seen multiple threads around this but still I'm surprised there is no dynamic solution for this, I have tried auto populating ROWID by AutoNumber column and as you can see in screenshot whenever I try to add a new row in between it calculates the row number from the bottom (WOW), this is very bad and this is…