-
Linking entire columns to another sheet
Hi Community, I have a master Intake sheet fed by an intake form, this serves the purposes of multiple departments. I would like to create a second sheet that automatically receives data from the primary intake sheet that only captures the requirements of a single department, this would imply to mirror only selected…
-
ISNA Excel Formula
I am trying to recreate an excel formula in Smartsheet that looks for the column Header word in the proceeding columns within that same row. If it finds the word in that row, it then places the word in the cell that the formula exists. So if the formula is in [Apple]1, it searches a specific range of columns in row 1 for…
-
How do I count the number of times dates appear within a range?
Hi, I am trying to track the number of times a call occurs within a date range in a cross sheet reference formula. The user types the date on the call log and I would like to use the dates as a way to measure how many times calls occur within a week, month, and project to date . I have tried different ways, but I am stuck…
-
Need per user formulas for counting cells
I am trying to create 2 formulas to get information for a dashboard. The first is a formula that looks at RYGB as well as assigned user and counts all cells if they match both criteria. I tried this but can't seem to get it to work: =IF([Assigned To]@row = "Clark Everson") AND(=COUNTIF(RYG:RYG, "blue") The second is a bit…
-
If then formulas
I am trying to create my own easy work around to capture the date when something is completed. IF the Completed Box is checked AND I have a last modified date column Can I create a date completed box and say IF the Completed Box is checked, then copy last date modified? =IF(Completed1,1, [Last Modified Date]1, "") Does not…
-
How to update a formula to automatically populate for the prior Monday to a cell date
Hi! I have the following formula from the discussion board (shoutout to Craig) for automatically populating the Monday prior to a certain date: =IF(ISDATE(Date@row), IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - WEEKDAY(Date@row) + 2)) What do I need to change on this to have it calculate the FRIDAY prior? I'm sure…
-
Auto-status, 'Up Next' criteria overlap
Hello! I am working on a sheet with Start/Finish dates and need to populate status' into the following 4 categories: not started, in progress, complete, up next For not started/in progress/complete i have the following formula working: =IF(AND([Start Date]@row < TODAY(), [Finish Date]@row < TODAY()), "Complete", IF([Start…
-
COUNTIFS Formula
I am fairly new to working with formulas. I have a Project Status column that contains several values with "In Progress". For example, In Progress - Scoping, In Progress - Development, etc. I would like to count all the instances of any variation of In Progress. I have tried working with HAS and CONTAINS and recently came…
-
Formula Not Working. Turning Sizes into Numbers
Hello, I am trying to write a simple formula where I translate a size value into a number. For example in my column called "Size": I want to create a formula that turns the following size into corresponding numbers in another column. XS = 1, S = 2, M = 3, L = 5 My formula is as follows, but doesn't work? =IF([Size]1 =…
-
Function to retrieve count in a multi-select column
Hi, So I have a multi-select column which upto 7 selections currently. What I am trying to do is have a bar chart of count based on the number of selections in each cell. To give an example. row 1 : A, B, C,D,E,F,G row 2: B,C,D,E row 3: A,C,D row 4: C,E,F row 6: A So what i would like to do is create a graph like number of…