-
How to Multi-select column show on Calendar
i have a multi-select column on the sheet summary report. like to show the selection selected from the multi-select column to show on the Calendar app and add filters from the multi-select column. any suggestion?
-
New here, general questions
Hi, Do you have to write all the functions yourself or are there tools to help with the process. I need to do a xlookup index and matching update to another sheet. I'm use to work with ablebits tools. While I'm here, it is possible to upload to a file to overwrite (update) data on a current sheet? Can I sync two sheets so…
-
Date 6 months out (to the day)
Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also new at SS, so I am just now learning syntex, etc., regarding functions and formulas.…
-
I need to use an IF / THEN formula to compare a cell from one column to a cell in another column
I could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN statements: 1. In STATUS, if the DELIVERY DATE is within SEVEN (7) DAYS of the START DATE, the LIGHT is RED. Can the DELIVERY…
-
Creating training Calendar
Hi All, I am currently trying to create a sheet to track who our trainers are currently working with. Currently have 15 trainers, but the team will grow larger in the next few months. Each trainer can train 2 employees at a given time. Employees are trained for 2 weeks. Ideally, I would like a form that someone can request…
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…
-
combining them in the same column
Hi, Can we show the date and time by combining them in the same column? thanks
-
How to calculating the age of a cell in hours
Background - I have a Form, which outputs as a row in a Grid, an extract of which is as follows - The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function). Problem - I am trying to find a formula-driven solution, which…
-
Currency view on Calendar
Having trouble showing currency view in my Smartsheet calendar. The data set it is pulling from has the right formatting. not sure what i may be doing wrong.
-
Can I set calendar view to open to today's date?
Hello, Last week we noticed that our calendar view was opening to a date several years in the past (Aug 2015) rather than opening to today's date (which it had been doing successfully all of 2021). This sheet was completed in 2021 so there are no dates entered that are prior to the creation date. I have changed the…
