-
Calculating a staged reduction in severity
I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
-
Less restrictive settings
I am trying to have less restrictive settings to send updates to people who aren't shared to my sheet. The help section suggests that: * Open the sheet and click Alerts & Actions > Manage Alerts & Actions. * Click the Settings icon in the upper right corner of the Alerts & Actions window. However, the last revision of…
-
Posting/Including data from another cell.
Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement is the value from one of the cells containing the time. This works, with no added…
-
COUNTIF Checkbox Marked and Then COUNT Product
There is a column called "Terminated" and it is a checkbox and 5 other columns with Product1, Product2, Product3, Product4, and Product5 which are also checkboxes. I need a formula to COUNTIF "Terminated" is Checked, then COUNT the Product1, Product2, Product3, Product4, and Product5 columns. For Example: Terminated =…
-
Rich Text Widget is suddenly missing Cancel and Done buttons and Scroll bar
Please see widget with title "In Progress Tasks." Here's the address: https://app.smartsheet.com/dashboards/fhmp8FhCp98HQfrj3RcH3mXpF9MCRvMv4Jv6p6M1 Andrée, please see the screen shots, one has the buttons but not the other
-
If statement based on date
I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19". =IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19" I am using the date format (2019, 8, 25) based on what…
-
COUNT by Manager and by Product
I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes How can I do a count by Manager of Product? Example: Joe Smith * Product1 - 3 * Product2 - 10 Jennifer Johnson * Product2 - 12 * Product3 - 5 * Product5 - 10
-
Formula counting State
I have a column called "State". How can I do a count by all "State" and produce a chart? I want to avoid doing a formula for each State. Suggestion?
-
Rollup Formula
I have a rollup sheet. I am needing a cross sheet formula to calculate total quote for a specific sales rep. See screen shots below. Thanks so much your help. I really do appreciate it!
