-
SUMIF using CONTAINS from a different sheet
Hello! I am trying to sum from a certain column when another column contains the word "RSMAS", this is what I am trying and it doesn't seem to work: =SUMIF({Completed Request - Safe Return to Campus Range 2}, CONTAINS("RSMAS", {Completed Request - Safe Return to Campus Range 3})) Any ideas? Thank you!!
-
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?
-
Sum incremental cells
Hi, I have 30 row in Col 2 and I want to return value in Col 3 at increment of each row.