-
Modified Date column not working
I have always done a 'save as new' with all of my sheets to archive data and then changed the Created Date column to Modified Date, that way it keeps the original created date of the rows in the archived version. However recently the Modified date is not changing, it is just mirroring what the created date field is. What…
-
Using If/or/and to change date based on different drop downs and checkmark selections
Hi all, Adding on to an existing formula to automatically add a number of days depending if a column is checked or not. The bone column is either "NA" or various types of bones which populates the final date in the QC column based what is selected. I'm trying to add if the Timeline extension box is checked, it will add the…
-
Formula to add 1 day to date
I'm having trouble with a formula to add one day to a date based on a condition. I'm sure it is something terribly simple that I'm just missing right now. My formula worked previously when I had AND in the formula with two conditions, but when I only have one condition it adds a 1 to the end of the date rather than adding…
-
I want to know the formula, if I want the total breakdowns from 1/1/2025?
In my sheet, I have a "Job" column, where it indicates if it was a breakdown or installation. I have a "Date of Job" column, but this goes from 2022. My goal is to calculate the total breakdowns for every year.
-
Date Added when my Primary Auto Populates?
Hello! I am trying to find a way to use an automation or something of the sort for when a specific cell is no longer blank. Context: Primary Column is linked to a hidden auto-numbering column The "Date Added" Column was working for a while but every now and then the sheet will add about 5+ empty but numbered rows at the…
-
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…