-
Client name incorrect in Contact List background and will not change
I inherited the Smartsheets/workbooks a couple of years ago, and I recently noticed (on an update workflow request I just created) that a client's name is incorrect. I can not change it. Any ideas where this name is stuck or how I correct it? When I tried to figure out why this happened, I noticed that the name appears…
-
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…
-
Notification Automation not working
I have set up a notification automation which would send someone a notification when the status of a deal changes. Attached Screenshots. However, I am unable to get any notification. Do i need to apply a different automation or is my current one missing something? Thanks!
-
Formula for changing drop-down selection in one column when a date is entered in another column
I have a status column with drop-down options (Not Started, In Progress, Complete, N/A). I would like the drop down selection to change to Complete when I enter a date in the Complete Date column. Is this possible?
-
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…
-
Can we have chart in sheet like we do in excel
Hi There, Can we have chart in sheet like we do in excel I dont want dashboard I want the chart % to be in sheet column Thanks
-
Dropdown List in Single Cell in Smartsheet
Is there an option to make one cell in Smartsheet have a dropdown list?
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
-
Report Summary - New function isn't working
According to this https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder I should be able to summarize my report based on ANY field. I am trying to summarize how many tasks an individual person has been assigned to. The help document says that a contact field should be…
-
Using IF with greater than or equal to a number
I want the "Complete" column to show "yes" if the total reviews is greater than or equal to 3. I cannot figure out what I did wrong with the formula above. Thanks!
