-
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!
-
Ignore blanks while detecting matching text across multiple columns
Hello! I am trying to write a formula for detecting ANY matches between "Affiliation" and "Affiliation 1," "Affiliation 2," or "Affiliation 3". If any of them match "Affiliation", then "conflict" is true. If false, it should say "none". However, if "Affiliation" is blank and matches another blank, it also outputs…
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
