Login

r/smartsheet

▲ 2 r/smartsheet

Workflow gone mad!

I’ve got a workflow that copies out when a form adds a record.

It’s been in place and working for years.

For some reason today when a record gets added and copied out it continues to copy out again and again.

Anyone else experiencing this. The Smartsheet status page says nothing but that is no surprise.

Update: the last run date isn’t getting updated and the workflow isn’t re-executing because I’ve changed it to update a column after execution but that column hasn’t updated.

reddit.com
u/FineConcentrate1134 — 7 days ago
▲ 0 r/smartsheet

Anyone else annoyed with how native forms look for external clients?

Hey everyone, we've been running into a huge issue at my agency. We need clients to fill out intake forms, but sending them a native Smartsheet form looks incredibly unprofessional (you can't remove the branding, the styling is rigid, etc.).

Since SmartSheet won't do anything about it, I decided to just make my own drag-and-drop form builder that will bypass these issues and sync directly to the sheet.

I threw together a quick page to see if anyone else would actually use a tool like this before I spend weeks coding it. If you hate native forms too, let me know what features you'd want: https://flexforms.carrd.co/

u/Wide-Opinion9246 — 10 days ago
▲ 1 r/smartsheet

Change & communication calendar

My team tasked me with creating a calendar view for out team’s changes and communications. There are also ideas of including projects and training on the same calendar. We are a global team of 100.

My leadership wants a way to see in the calendar view who the audience is and there are potentially 10-15 audience types.

I have started with a report with each item. Kept it simple with dates for each, type (communication, training, process or project launch, etc.), and audience type. I color coded the audience types so that it would show a different color for each on the calendar view. But the colors start to not make sense because there are so many. I am wondering if a gant chart with different audience categories would be better than a calendar view.

I am struggling to think of the best way to do this. I am wondering if there are complex change/communication calendars that others have built that work well for them?

reddit.com
u/Old_Log_4974 — 9 days ago
▲ 1 r/smartsheet

Automation workflow trouble

I’m trying to use an automation workflow to send row information to contacts in a cell.

I have outside entities send an excel spreadsheet to my Smartsheet via a Form, which attaches the spreadsheet. Data Shuttle extracts this and puts the data into rows properly. My workflow fails to send the emails, so I must have an error in the relevant column or in the workflow. The column is set up as a contact list.

I’d appreciate help in troubleshooting this.

reddit.com
u/MississippiMark — 8 days ago
▲ 2 r/smartsheet

Why remove cards?!

I understand Smartsheet are removing the Card view, forcing us to use the Board view.

Anyone know why? Seems like a dumb idea - board view is even less user friendly than card view!

reddit.com
u/FineConcentrate1134 — 9 days ago
▲ 138 r/smartsheet+1 crossposts

VLOOKUP function with curly brackets in Excel | How do I do a VLOOKUP with multiple columns at the same time? - Excel Tips and Tricks

Discover how to use VLOOKUP function with curly brackets in Excel. It is essentially vlookup formula with curly brackets. I will also answer what does curly brackets mean in Excel formula?

VLOOKUP is one of the most widely used functions in Excel. It enables users to search for a specific value in a table and retrieve data from a corresponding column. However, in some cases, users may need to look up data from multiple columns simultaneously, and this is where the VLOOKUP function with curly brackets comes in handy. With this technique, users can perform a VLOOKUP operation across multiple columns at once, which can save time and improve data accuracy. In this article, we will explore how to use the VLOOKUP function with curly brackets in Excel and provide some practical examples to illustrate its usefulness.

Create Drop Down List

  1. Select cell A2

  2. Data ~ Data Validation

  3. Settings tab

  4. Allow set to List

  5. Source set to =$A$5:$A$43

  6. Apply

  7. Select cell B2

For Model

=VLOOKUP($A$2,$A$5:$E$43,2,0)

For Total Cost

=VLOOKUP($A$2,$A$5:$E$43,3,0)

For Qty

=VLOOKUP($A$2,$A$5:$E$43,4,0)

For Country

=VLOOKUP($A$2,$A$5:$E$43,5,0)

Data In Horizontal Format

=VLOOKUP($A$2,$A$5:$E$43,{2,3,4,5},0)

Data In Vertical Format

=VLOOKUP($A$2,$A$5:$E$43,{2;3;4;5},0)

What does curly brackets mean in Excel formula?

Curly brackets are how Excel recognises the numbers as an array formula.

What does curly brackets mean in Excel formula?, vlookup with curly brackets, vlookup with semicolon, excel multiple vlookup * field curly braces comma semicolon,excel formula for vlookup * field curly braces comma semicolon,excel multiple vlookup field * curly braces comma semicolon,excel formula for vlookup field * curly braces comma semicolon,vlookup formula with curly brackets,curly brackets in excel formula,what does curly brackets mean in excel formula,curly brackets in excel,excel curly brackets around formula,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

u/Caligarick — 12 days ago