Survey results (and what's coming next)
Thank you all for giving us your feedback in the recent Smartsheet Community survey! Based on your thoughts, we're excited to announce that we have many changes coming in just a few weeks. Read our survey recap post for more details.
Comments
@Megha Brahmbhatt It looks like you have an extra closing parenthesis after your first range in the COUNTIFS.
=IF(COUNTIFS(Site:Site)..........
Remove that and see if it works for you.
thinkspi.com
@Paul Newcome ,
I read this blog. It is very useful.
I do not want time overlap. For me only date overlap of particular column is important.
I am confused about the formulas. I have only 2 columns "task start date", "task end date". I want to trigger an overlap when 2 are more dates same on "task end date" colomn. Can you please help
@Muni Pavan Kumar Reddy Kona Are you only wanting to compare the end date column, or are you wanting to also incorporate the start date column?
thinkspi.com
@Paul Newcome , I want only end date compared in all cells, if two or more end dates are equal we need to flag
@Muni Pavan Kumar Reddy Kona If you just want to flag any rows with equal end dates, it would look something like this...
=IF(COUNFITS([End Date]:[End Date], [End Date]@row) > 1, 1)
thinkspi.com
@Paul Newcome ,
It did not work, Please find the attached screen shot.
@Muni Pavan Kumar Reddy Kona What exactly do you mean by it doesn't work? Is it not flagging duplicate dates or are you getting an error code?
thinkspi.com
@Paul Newcome , My apologies. It it working. Actual formula you gave is below.
=IF(COUNFITS([End Date]:[End Date], [End Date]@row) > 1, 1
But small typo =IF(COUNTIFS([End Date]:[End Date], [End Date]@row) > 1, 1)
I placed them as flag it perfectly work fine for me. Thanks for your help.
@Muni Pavan Kumar Reddy Kona Sorry about that. Sometimes my fingers move a little faster than they should.
thinkspi.com
@Paul Newcome I saw a sheet you made for someone else creating a flag for date and time overlap. Can you share that again?
@TsmithFastSigns Take a look at the below thread. There should be what you need in there somewhere. I think it is up to 9 pages now. Hahaha
thinkspi.com
@Paul Newcome You are such an asset to this community. Good man!
What am I doing wrong here, @Paul Newcome
=IF(COUNTIFS([VEHICLE #]:[VEHICLE #], [VEHICLE #]@row, DATE:DATE, [email protected], FINISH:FINISH, @cell >= [email protected], START:START, @cell <= [email protected] > 1, 1)
I changed your [virtual license] to [vehicle #]. I'm trying to make a vehicle schedule that will notify of overlap of vehicle use.
I'm getting "INCORRECT ARGUMENT SET" as an error.
@TsmithFastSigns You just forgot to close out the COUNTIFS.
=IF(COUNTIFS([VEHICLE #]:[VEHICLE #], [VEHICLE #]@row, DATE:DATE, [email protected], FINISH:FINISH, @cell >= [email protected], START:START, @cell <= [email protected]) > 1, 1)
thinkspi.com