-
COUNTIFS Less than Today on a referenced sheet = INVALID OPERATION
I'm referencing another sheet and want to count rows belonging to a particular individual where the planned date is in the past. I'm trying to COUNTIF Owner@row and Planned date is less than TODAY() Here is my formula but I'm getting an INVALID OPERATION error. =COUNTIFS({520.07db Qualified Testing Facility Databa Range…
-
How do I integrate a way to pay for an event for my guests?
I am using smartsheet forms to collect registrations for my upcoming event. I would like people who register to submit payments to confirm registrations. How do I do this?
-
Formula on checkboxes
Hello all, I am trying to find a formula that will show me progress based on 3 or more columns that are checkboxes. I want to show progress if one of them is checked, I want this new column where the formula will be to say not started if all are not checked and completed if all are checked. Can this be done? I tried to…
-
How to work around this Cirular Reference Error?
Hi everyone! I am working on an Inventory sheet for my business and it is not allowing me to do what I need, IE(CircularReference Error). I have a [Starting Inventory] set at 20 in my 'Master Inventory' Sheet. Then I have 2 Forms that are filling in the [Inventory IN] and [Inventory OUT] as my team re-stocks and takes off…
-
COUNTIFS with Parents/Childrens AND/OR and multiple columns
Hello, I have spent HOURS on this and help. This for "Invoice/Sheet Received" Parent column with drop downs. I am combing the Parent code AND child codes so can click+drag it down my sheet. I want to keep this. So the first part of this is for the Parent, the 2nd is in relation to the child. I keep getting Errors on my…
-
Help with SUMIFS formula to display todays census
Hello, Every day three service line VPs complete a SS Form. The form's information indicates todays date, service line, and a census. I need a formula (I presume =SUMIFS) that tells me the census for one of those service lines for only 'today's date'. That sum then flows to a dashboard widget so leadership can view only…
-
Is character count in a cell is increased from 4000 per cell?
Hi, I just wanted to know if the recent enhancements of smartsheet has increased the character count per cell? I want to use nested if for around 70 products, satisfying each product name and I think that nested if is going to exceed the limit.
-
SIRI / Voice Assistants
Good afternoon. Is anyone familiar with how Smartsheet works with voice assistants? More specifically, can I input a new task into Smartsheet with Siri?
-
How can I autopopulate end date with months duration without using dependencies?
Hi all, I am trying to work out how to autopopulate end date of the project based on start date and duration I have in months. I am trying to avoid using dependencies as those do not support months, only weeks, and that is not an exact value. We have several hundred projects running at the same time so really going and…
-
COUNT COLLECT To Find Rows For a Specific Date Not Working
Hello, I have a JOB SHEET that shows jobs assigned to one or more persons in a "Resource" contact column. This sheet also has the dates for "Start" and "Finish" to determine the date range that the project will be worked on. I have a separate Sheet (Sheet 2) that is intended to return the number of projects a specific…
