-
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.…
-
Cross sheet formula reference's not working as expected
This problem is going to be really difficult to explain but here goes it..... I have a sheet with Jira ticket information, including Creation Date and Resolution date. In other sheet I am doing calculations using these two columns to capture the correct data. While creating the formula, I click Reference Another Sheet to…
-
CREATING INTERACTIVE FORMS / DASHBOARDS
Hi everyone I have developed forms for collecting data remotely. and dashboards for publishing the data..fairly straightforward. What I would like to do is to create an interactive form/dashboard that accesses the information in the sheet. As an example, we have a sheet that has monthly written reports (not as an…
-
Drop Down List / Column (add to list, based on User entry)
I know you can restrict the Drop Down List by what you enter into the list; however, my question is, if I create a form or have the end user enter a new entry (for the Drop Down List), can that entry now be part of the entire Drop Down List? For example: The unrestricted Drop Down List is: Apple, Banana, Pear and then…
-
Proofing Review Request
Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the "Set up Review Request"? We have some people who are admins and some who are not who would use proofing. I want to make sure anyone can send out a review request, but wasn't…
-
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…
-
Workflow Copy Rows...
Ok, So I'm trying to use these new workflow ( https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets ) and I'm running into an issue... So I'm in the sheet I need to copy from, and I create the workflow and select 'Copy Row' and when go to select the sheet I want to go to it does not…
-
Need to add new columns in SS to my form that I have created
I have created a New form, but them realized I needed to add additional columns to my sheet, these new columns are not populating into my form. What do I need to do to get new columns in my existing form, do I need to duplicate and then delete the old one? Please advise or send instructions?
