-
Assistance w/ automated Checkbox based on multiple conditions
Hi All, I'm after some assistance regarding a formula to automate a checkbox based on multiple conditions. These are; Column "Requested by" is populated with a date. Column "Site" is populated. Column "Site contact" is populated. Column "Quantity" is populated. Column "Product" contains the word "Device" Then a sum is used…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
#UNPARSEABLE using COUNTIF for text objects
I have a Form which allows the recipient to answer a question via a drop down list: Example: Where would you like to go for vacation? List includes: U.S., Europe, Asia, Australia It's a pick many list so users can select any number of answers. The resulting cell then may contain something like: U.S. Europe Asia I would…
-
Converting a formula to a "column formula"
I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The Same would apply for Cancelled. If all tasks are complete, cancelled or n/a, the overall status would be "n/a". If…
-
Filling Columns based on a Selection From Dropdown
I am working on a formula and cannot get it to return correctly, I need to be able to select one of two options in a dropdown. I was using a vlookup and kept getting the N/A for all of them even if the condition was met. I think I missed an additional trigger. Regions: ABC and XYZ for the example. Based on which region…
-
Formulas & Filter Assistance for a To Do List
Hi, I have tried a few searches and haven't quite found what I need to perform the function within my smartsheet. Hoping some of the Formula wizards can help me out. I am using Smartsheet to manage my to do list. The filters are great but only make allowances for 1 or ALL conditions, I require 2. I am wanting to create a…
-
Countif todays date and by someone
I want to count how many times someone completes a form today I was able to count if yesterdays date with: =COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1) but can't find a way to calculate todays entries
-
CheckBox Formula
Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Status column show Complete. I have partially achieved this with the following formula: =IF(Done@row = 1, "Complete")…
-
Is it possible to send specific columns of two spreadsheets to a third one?
Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, deleting rows and changing data. I am working with many data. Thank you, Belia Báez
