-
Check a Checkbox
I'm working with two columns, "Status" (Dropdown) and "Complete" (Checkbox). I'm finding not everyone checks the checkbox so I'd like to put a formula in that cell that will check to see if the checkbox in "Complete" is unchecked and "Status" is Complete, mark the checkbox. Is that possible?
-
Conditional Dashboard Formating?
I have a sheet with several rows, and those rows may or may not have sales orders. If the row has a sales order then its booked, if it doesn't then it's pipeline. I'd like to have a dashboard pull data from this sheet that adds up all of the rows that contain an SO and also add up all the rows that don't have an Salesโฆ
-
Updating Approval Status Column based on two other Approvals
Hello, I have an "Approval" column that I want to automatically update to "Approved" if two other columns are also "Approved." I have tried different formulas, but am getting an error "Unparseable." My two columns that need to be in an "approved" status are "Executive Sponsor approval" and "Additional Approvers approval"โฆ
-
Auto Fill
I am looking to see if there is a way to auto fill a cell. I have created a sheet to track new hires. I am looking to find out if I can have 3 cells populate to " Not Started" when a new hire is requested thought our form link. Right now we can go to the end of the form and choose from the drop down, but it would be niceโฆ
-
Column Formula for Joining Cells
I am using this formula to join the two cells and when trying to make it a column formula it is saying it's a syntax error, can someone please help? =[Part Number]1 + "_" + Rev1
-
Column Formulas for Duplicates
Identifying duplicates with consideration of blanks This is the formula I am using to identify duplicates and trying to omit blanks and it is giving me a syntax error, can someone please help? Also, could I make this a column formula? =IF(ISBLANK([Folder Name]),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row)โฆ
-
Update Cell if A Different Cell Changes
Here is my problem: Column A has dropdown values: Open, closed, pending, approved Column D has dropdown values: Approved, Deferred, Escalate I created a helper column and what I'm trying to do: if column D change to approved, column A will also go to approved If column D changes to escalate. column A updates to approved ifโฆ
-
Why is a simple division formula not working?
I am trying to divide two different cells into another cell. I am taking my information from my quantity column (qty3) and my rate column (rate3) and divide them. I want it to look like this =QTY3/RATE3 but it always comes up #INVALID OPERATION. I also changed the symbol to addition and it did not add the numbersโฆ
-
Counting Parent Rows
Good Morning, I have smartsheet Parent and Child rows. How do I count the parent rows? Also, how do I COUNTIF for parent rows that meet a certain criteria? Thank you so much for the help!
-
Formula to get most recent status for a particular client
This is a repost of a question I ended up solving myself, but have run into another issue. Here's the setup: I have a "History" sheet that logs the results of form submissions: I have a second sheet, the "Summary" that should look something like the below image, showing the status of each category from the most recentโฆ