-
grey out specific number of days in calendar booking form
Hi, Is there a way to grey out let's say 2 days from the pop-up calendar so end-users cannot book equipment for 'today' or 'tomorrow'? For instance, today is 5th May and the calendar will show 6th and 7th as unavailable / not able to select for booking. Thank you in advance!
-
Rankadv dates, or DATEVALUE
Hi, I was trying to rankadv a series of dates (to calculate employee seniority), which isn't yet a feature. Since I cannot do that, I wanted to turn that date into a number that I could then rank, which in Excel I can do with the DATEVALUE function. Is it possible to get either of those in SmartSheets?
-
Formula To Count The Number of Days an Incident Occurred
I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Green" day. The goal is to make a chart that shows number of red days out of the month. A day will be considered red regardless…
-
Different Dates on the one sheet
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The Created date, being the system generated date is correct, but as you can see the Inspection date using the above formula is…
-
Suggestions for making readable schedules / Conditional formatting last occurrance
Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day contains 5 or more tasks on average. The supervisors who populate the schedule are having trouble when editing rows because…
-
Select Most Recent Date In List
Hello! I need a formula to pull the most recent date in a list, but I keep getting unparsable and invalid errors. Could someone please help me create a formula to put in the highlighted cell? Please note there are empty dates (like the top row). This sheet is driven by a form, so new dates may be added out of order - in…
-
Display date and duration by referencing other cells in the same sheet
Hello Everyone, I'm trying to reference data from row 44 into row 3 in the same sheet. "=[Task Name]44" works like a charm (see below). However, =[Start]44 doesn't result in the date "08/13/25" being reflected in row 3. Likewise, =[Finish]@44 doesn't reflect the Finish date from row 44. =[Duration]@44 or =Duration44…
-
Linking my pacing sheet to a dashboard - if the date column is Today, return the total hours for the
Hello, I am trying to set up metrics for a lab testing schedule. I have created a pacing sheet which is set up to show how many hours of testing each analyst is assigned that day. The left column is the date, and the column next to it is the total hours assigned for the day. I would like my dashboard to show the total…
-
How can I display the current month number as a 2-digit number so it matches my year-month?
My ultimate goal is to create an automation that will look at the total audits completed for the current month and if the number <10, a notification will be sent. In order to do that, I need the 'current month' and 'current year' formats to match the 'Month' and 'Year' formats. I have tried =TEXT(TODAY(), "MM") but get an…
-
"Substitute" Column Formula Inconsistency
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen shot below that it doesn't always work. Is this a bug?