Best Of
Calendar Y/N Toggle
I have a sheet I use for PTO. On that sheet is a Checkbox labelled "Delete" (first image). I render the dates on the Calendar app (second image) and then when a user double clicks an item they get the details sheet - allowing them to select "Delete" (third image). Why does the checkbox appear as a dropdown? I just want a toggle (yes/no), which is what I setup on the sheet.
dpm1028
Re: INDEX LOOUP Workaround
@APicard_AZ I would suggest putting it all in one sheet and then having two reports (one for production and one for qc). The reports will allow users to interact with the sheet but still allow you to only display the columns that are needed for each.
Paul Newcome
Re: INDEX LOOUP Workaround
Hello @APicard_AZ!
Just tagging you to make sure you don't miss Andree's response!
Marcela
Re: INDEX LOOUP Workaround
Hi,
I hope you're well and safe!
1️⃣ As you mentioned, you could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
2️⃣ Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet, use my previous method to get the values you need to another helper sheet, and then copy/move the row from that sheet to the main destination sheet.
To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row ID on as many rows as you need in the Destination sheet.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Pivot App is not recognizing the Contact Columns
I am having the same issue. It has worked for years, but not now.
Jeanne Nickoloff
Display Report Summary Gantt
Currently, when you do a report summary, it will pull in tasks from multiple sheets and group them per selections. It shows the Gantt chart of each of the tasks, but does not show a bar for each of the summary groups—I would like to see it work the same way subtasks work on a regular sheet, where it shows a bar from the beginning to end of all subtasks in the group.
esnow
Re: What size image, width x height, is best for a background logo on a form?
I have this issue. I don't understand why it's hard to get an answer on what is the size that you should make the image to avoid distortion.
tworthington
Re: Request for Rollback - create sheets in Sheets folder
@Emain123 ya, no suprise there, you can see how they responded early on in this very long ongoing topic - see link here 😒
Julie Becker
Re: Lock a date even if it has predecessors
Having a Gantt chart option puts Smartsheet in the same realm as MS Project. I was surprised that there was no way to lock a milestone. It is one of the most critical features of scheduling. Can I upvote more than once?
Helio
Upcoming Smartsheet User Group Sessions
📣 Want to connect with fellow Smartsheet champions? Smartsheet is hosting in-person User Groups around the world! These free events are a great opportunity to learn from local users, hear success stories, and share your own Smartsheet experience during the workshop and networking hours. Space is limited—save your spot today!
Here’s where we’re headed:
- Manchester, UK - May 1st
- Denver, CO - May 7th
- NYC Area (Hoboken, NJ) - May 14th
- Stockholm, SE - May 20th
- Boston area - June 5th
P.S. Don’t see any groups in your area? We also have a number of upcoming virtual sessions!
Check out our page to register for any of these events.
Kelsey Hayden