Hello Smartsheet Masters, I am making a scheduler sheet for equipment slots. The sheet contains these columns: Conflict (Checkbox), Row (Dropdown list), Slot (Dropdown list, multi-select enabled), Sta…
What should this formula look like if I also want it to ignore any tasks that do not have an end date? =IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete")), 1, 0) Its template formula from a proj…
Hello, In my Smartsheet sheet, I'd like to set up a system to check off meetings automatically. I'd like to enter a date (ex: 04/15/23) in a column and the time span in another column (ex: 12:30 - 2:3…
I am trying to transfer sheet ownership to an existing collaborator who is already an Admin. This message appears "This user cannot accept ownership at this time. Please retain your ownership or selec…
Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Ma…
Curious if images in a dropdown list would ever potentially be able to become a thing. I found this old (Circa 2016) archived post indicating that is coming in the future, so wondering if it'll ever b…
Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who rec…
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the d…
hello everyone, I created a dashboard to act as a huddle board for the business meetings and we will need about 100 different dashboards but dont want an update on one board to impact the other boards…