-
How do I count if someone attended?
Hey! I've been messing with this formula for a bit, and I'm kinda stumped. I'm trying to count how many people have attended a course on a certain day. So, if "Attended" is checked on 1/23, then that should count as one person attending. Columns Referenced: Attended = Check Date = Date format…
-
How to use Index Match on multiple criteria?
So, I found some articles explaining how to use Index Match on multiple criteria. However, when I try to do so I get a #Invalid Value error. My current formula is: =INDEX(COLLECT(Task:Task, [% Complete]:[% Complete], 100, Milestone:Milestone, 1), 1) What I want Smartsheet to do is to show the task that has been marked as…
-
Workflow for Locking the rows in Smartsheet Automation not working!!
Hello, I tried to lock rows for editing using the "Lock Rows" action in Smartsheet Automation as well as locking the rows manually. The Dynamic Link user on my sheet can still edit the row content even though it is locked ( i can see the lock icon on the row). Just to add the users on my sheet are not licensed user. Please…
-
Update a cell on a master list from individual identical laid out sheets
I have a template that I use to create data sheets for unique projects. All rows and columns are the same for each project. I also have a master sheet that lists all the projects which are populated with information from the same cell location from each project sheet. I have been able to go from the master sheet to the…
-
Tabulation formula
Trying to create a formula to track the number of instances a specific cell value occurs within a given month. Relevant columns are "Publish Date" and "Partner ID" and I need to tabulate how many times the Partner ID value "RNO" occurs within a given month. Here's what I have so far (from the template), which renders the…
-
VLOOKUP and IF - THEN
For simplification purposes I am a smartsheet that has 5 columns in it: 1) Month (this column has each month in a cell ; A1 = Jan, A2 = Feb, A3= March, etc) 2) Date (this column has an exact date in it (i.e. B1= 1/30/23, B2 = 2/20/23, etc) 3) This column has a check box to represent if it is an "Off Month" 4) My current…
-
Automate symbols
This should be easy but I am stuck trying to figure out how to get the symbols to work in a formula to reflect health of budget percentages. All the single lines work except the green one - it just shows up blank, with no error (the highlighted drop-down has the green formula only like below) I have tried the combo forumla…
-
I need to create a "Service Report #" that pulls info from 3 cells
Hi there! I need to create a "Service Report #" that pulls info from 3 cells: --"Portfolio" --"Site" --"Date" Where for Portfolio and Site are an abbreviation of what's in the cell (i.e, "Newport News" becomes "NN"/"Middlesex" becomes "MSX" and the date is 6 numbers with no punctuation (i.e, 01/24/23 becomes 012423). My…
-
Formula to move over one cell
Hi there! It looks like there's not yet a solution to move over columns/selected data from one sheet and merge it into another. However, I was wondering if I could move over one cell from sheet 1, based on an update in Sheet 1, into a cell in Sheet 2. Sheet 1. Approved Column is updated to "Yes, Approved..." Sheet 1.…
-
Click a button and have hours spread across depts
I am trying to figure out how to automate taking one number and spreading it across a number of different cells. I have created a sheet where I track my time and allocate it out across the depts I support. There are over 15 depts and 8 of those are very common to spread time out to as I run projects for them specifically.…
