-
auto incremental's from form data
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
-
Conditional Formatting Not Working with Formula: change colour based on date
Hello everyone, I'm trying to conditionally change the background color of a date column based on if it is today or yesterday. It works just fine if I type in a date, but if the date is populated via formula then it doesn't work. I have tried disabling and re-enabling with no luck. The cell in question references 2 other…
-
Template and use of formulas
I am using a project plan template and have some formulas on the Health prebuilt - however if someonee adds another task via insert (which they should be able to do) it does not carry/maintain the formula on the newly added Health column. Please advise.
-
Alert Someone on every day a Task is marked as happening
Hello, Can I create an Alert (Alert Someone) that would send a notification to an email for each day when a task is listed as happening in relation to the Start and Finish dates, inputted in the system? The logic cannot be static, and should be based on when a task Starts and when it is listed as Finished. Dates can vary.…
-
Parent/Child Formula
I need to create a formula where the parent row determines what it displays in its cell based on the following criteria from the children: If any child cell below it is blank, skip it If there is a name in any child cell, add it to the parent cell If it is a duplicate name in any child cell, skip and do not add to the…
-
Count Multiple Criteria
I'm trying to count a number of different items with multiple criteria. This is how I currently have it : =SUM(COUNTIF(Department:Department, "03 AACA Finance") + (COUNTIF(Department:Department, "03 AANJ Finance e"))) Is there an easier way since SS doesn't do arrays or do I need to keep adding the COUNTIF to the formula…
-
Forms - SmartSheet Form not the same as Form received by Action Parties to enter data
I have a Smartsheet that tracks Action Items. I created a Form that shows Action Parties data from Smartsheet and requires them to enter responses. The Form sent to Action Parties that appears in Emails and can be opened from the Email to enter responses does not contain the same cells as the Form in SmartSheet. Why? See…
-
Ability to create a form that will reference rows instead of columns
I have an existing extensive sheet that is built upon rows, i can only seem to create forms based on column headers, is there a way to do this for rows?
-
Contact Lists and Formulas
Hello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-assigning a job. The formula works for inputing the right name, but only as text. Is…
-
COUNTIFS Formula "NOT" error
I want to calculate something for a dashboard. My formula references our team's tracker sheet. I am looking to use COUNTIFS for Tasks that are a specific Request Type, not a grand parent row, and not in our Archive section. The first part of my formula works, my Archive NOT rule is what gives me an error. I've included a…
