Best Of
Re: What is the formula to flag duplicates from a multi-select drop down column?
Hey @sambittner,
You can make a list of all the available times, set the sheet to public, and create an automation that locks the row once someone has entered their name into the time slot. You could also set another automation to approve or deny the appointment which if denied would clear the slot and unlock the row for another person.
If you want to continue your original direction the formula you are looking for needs to contain the HAS function. The issue with that is you need to check for each time slot option so you would need the list of all times available either inside the formula or listed out somewhere else. I would break the sheet into two with the top portion containing all the times separately on single rows and the second portion for entering appointments. This way the top portion can check to see if any time is listed more than twice.
=IF(AND(COUNTIF([Time of Visit]:[Time of Visit], HAS(@cell, [Time of Visit]@row)) > 2, [Time of Visit]@row <> ""), 1, 0)
Re: Add Column to Row Report that was not in original sheet
The dynamic view solution is overly complicated, It would be nice to be able to add columns to reports for sorting and presentation purposes.
Is there a way to show a parent task on a row-sheet report?
I am creating a report, pulling from multiple sheets, that shows upcoming tasks in the next 7 days. The problem I am running into is that there is no hierarchy shown on the report. I get a list of tasks, but I do not know what 1) sheet they're from or 2) what phase/parent task they are related too.
Is there a way to show the hierarchy when reporting? ie)
Primary task
- sub-task 1
- sub-task 2
- sub-task 3
Primary Task 2
- sub-task 1
- sub-task 2
- sub-task 3
I want to thank you for the help in advance.
Re: Formula for IF cell is NOT BLANK and value < 'x"
Hi @Simon Potton,
NOT(ISBLANK(column@row)) is how you check if something is not blank.
You could use AND to combine both.
IF(AND(NOT(ISBLANK(column@row)), column@row<'x'), valueiftrue, valueiffalse)
Countif using Dates and another Range
I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT reply. Not sure what is wrong. Below is a copy of my Formula.
=COUNTIF([Request Create Date]:[Request Create Date], >=DATE(2018, 1, 1), [Issue/Nonconformance]:[Issue/Nonconformance], "Install Vendor Workmanship")
Re: How to create a request order form for multiple items/quantities
Hi @Angela B.
I hope you're well and safe!
I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Re: Combined Update request across multiple projects/sheets
Hi @tariq.shaikh@signspecialists.com ,
Have you considered using the scheduled "send as attachment" option on the report to remind people daily to make updates? It's not necessarily an update request, but is better than nothing.
Having update requests sent from reports (rather than individual sheets) would be a great feature to suggest to Smartsheet!
Re: Automate manual data entry
You can use a COUNTIF formula to check a box if there is a count of 1 (or more) of your criteria across sheets. For example, put this in Sheet 2:
=IF(COUNTF({Work Order Sheet 1}, [Work Order Number]@row) > 0, 1, 0)
This looks through your Work Order Number column in Sheet 1 and checks to see if the current Work Order Number in this row (of Sheet 2) appears in that sheet. If it does, all is well and it checks the box. If there is no instance, it will return 0, or an unchecked box.
Then once you have this indicator on each row, you can set up a Copy Row workflow that checks the sheet once a day to copy over rows that have an unchecked box, like so:
Cheers,
Genevieve
Re: Datamesh
Hi Michael
Based on my experience with Datamesh, I would recommend (and i think Smartsheet does too) using cross-sheet formulas. See: https://community.smartsheet.com/discussion/alternative-vlookup-smartsheet
Hope this helps?
Sean Williams
Re: Sheet randomly wiped all data
Hi @KMcGregor
I hope you're well and safe!
Have you checked so you don't have any active filters?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!I hope you're well and safe!