-
Time formula
Can anyone assist with writing a formula using military hours? See example sheet fields below.
-
Feature Request – Enable Copy and Paste for Header Columns
I would like to request a feature enhancement that would allow users to copy and paste header columns within Smartsheet. This functionality would significantly improve workflow efficiency, especially when managing multiple sheets with similar structures. Currently, users must manually recreate column headers, which can be…
-
automatically apply =Min/Max of descendants formula to parent rows based on hierarchy number?
is there a way to make those 4 date columns automatically apply the min/max formula once hierarchy is changed to 2? converting to a column formula does not let me edit the white/blank hierarchy date columns. and i tried doing an automation workflow to change a cell value, and the date columns are not options (they are NOT…
-
auto-populate date formula when column is checked
Hi All! I am looking for a way to add the date to a column when a check is placed in another column. I would want the date the check mark was added to the column. Any advice for the formula? Thanks kindly!
-
Display values from a row when a value in that row is a specific value
I am trying to create a reporting dashboard that displays elements of a row when a value in that row is "Yes". For example, if a workstream is blocked, the reference cell is "Is Blocked?" and if the value is "yes", I would like to display on the report the details of the workstream, the owner, and the reason it is blocked.…
-
Best practice to notify/ask if someone's name is selected from a drop down?
Greetings- I'm trying to figure out if the way I am doing it is the most streamlined way. I have a column called assigned staff where someone can select a single individual or multiple staff members. Once selected they are emailed with info from the grid asking if they are free during form submitted time (ex meeting time).…
-
Help with SUMIFS
I am trying to collect the numerical value based on whether or not work was completed between two dates by a specific employee that was assigned to the work, using SUMIFS. =SUMIFS({Numerical Size 1}, {Date Task 1 Complete}, >={Week 1 Start}, {Date Task 1 Complete}, <={Week 1 End}, {Assigned To}, Employee@row) ALL results…
-
Cross Sheet Reference Shows #REF When Row Is Moved
I have an intake form setup in one sheet and in another sheet I have a bunch of formulas to format the data from the form into a csv that can be used to upload the information into Jira. I have everything working, except when I have the row removed from the intake sheet (because it's been completed) I get #REF in my sheet…
-
CountifS with Distinct
I need a function to count how many time a territory as unique SIDs in a sheet. I tried the function below but it won't work. =COUNTIFS({Total URV Visits Range SID}, DISTINCT({Total URV Visits Range SID}), {Total URV Visits BEC}, District@row)
-
Redefine a formula for status and date
Changes needed to my current formula. There is just too much going on, I want to simplify this. My current formula in the "Certification Complete" is below. Now I also wish to change these colors to words: Green - Complete Yellow - In Progress Red - Not Started In addition I want the Certificate date field to be automated…