-
True/False VLOOKUP if cell on one sheet appears anywhere in column on another sheet
I'm trying to created a VLOOKUP formula the checks whether a cell value that lives on the same sheet as the formula can be found in anywhere in a column on a corresponding sheet. The formula should return a True/False value, or check a checkbox - whichever is simplest. I'm fairly certain the cell value should appear asβ¦
-
Voting using Symbols Formula
I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I have a "Tally Vote" column that I want to use as a summary of sorts to reflect status at a glance inβ¦
-
Formula to turn the background red
Hi, I have been struggling with this one. I want background in the column "B", column "C" and Column "D" to turn Red Automatically if the date in the column "A" was more than a week ago. Any help will be appreciated :)
-
How to throw an Error deliberately
Hi, Is there a way to deliberately throw an error in a SumIF formula ? I am calculating columns of Balance Due = Cost * Quantity but if Quantity is blank it returns zero or "No Qty", but I want it to throw an error so I when I sum up total Balance Due I'll know that I'm missing information. Thanks!
-
Auto Flag a row for Multiple Conditions
Hi, I need to auto flag a row if any of the dropdown in the RAIDD column is selected. (extra D is for Decision) =IF(RAIDD@row = "Risk", 1, 0) This formulae works and flag the row. However, how do I get others added like Assumption, Issue, Dependency, Decision =IF(RAIDD@row = "Risk", "Dependency","Issue" 1, 0).......Thisβ¦
-
Counting single select options from form
I am needing to count up the amount of times people select each option from a single select drop down on a form. I am creating a new spreadsheet just for these counts. Does anyone know a good formula for this?
-
Search a source sheet for date, employee email, and a checkbox and return the time
I am trying to build a clock-in/clock-out system. I have a form set up for my source sheet where employee can easily open the form, check the box for clock-in or clock-out and submit the form. From there, I want to pull that data into a time sheet for each employee... I am attempting to find a formula that will pull theβ¦
-
Friday to Friday pull
Hello SmartSheet World! π I am in need of yet more assistance .... I would like to build a formula that would pull some data from Friday to Friday opposed to just using a 7 day week pull. Here is a sample of my data This is the formula I am currently using but I have to keep changing it every day so that it correctly pullsβ¦
-
Auto-date function based on dropdown menu
Hello, Looking for some help in getting automatic dates to populate based on a status update dropdown menu. I'm working on a smartsheet that tracks quote requests. Right now I have a status drop down menu that triggers automation. I also have dates in separate columns that track when the request was sent to a vendor, whenβ¦
-
Is it possible to increase the amount of date range requests within a single formula?
Hi, Is it possible to increase the amount of date range requests within a single formula? I'm currently trying to return a value for first half of year and then 2nd half but for multiple years? It appears to be working for the 2021 year but not for the others. Here is what I currently have: but receive unparseable errorβ¦