Sheets
Discussion List
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. …
- Hi Smartsheet, Please make it simpler to populate columns in the Alert Someone automation. Clicking from a drop down would be much easier than having to type in the {{ }} and the column names. Thanks,…
- I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time…
- Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Shee…
- Hi Smartsheet, I'm looking to remove an automation Copy Row with another process and am looking for ideas, suggestions, help. Currently I'm using the Copy Row automation to drive data into an approved…
- This discussion has been merged.
- Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional …
- Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due task…
- I am creating a form to schedule meetings however, I need the times I have listed in Pacific Daylight Time (PDT) to be converted into Mountain Daylight Time (MDT) (PDT+1 hour), Central Daylight Time (…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
