-
💡 Healthcare & Life Science August Solution Spotlight - Opex & Strategic Planning
🖐️ Hey there Smartsheet Community! We have an exciting Solution Spotlight on August 14, at 1 pm EST / 10:00 am PST. In this Solution Spotlight, we'll explore how Smartsheet can help you seamlessly integrate Accreditation Management, Project and Portfolio Management, Mergers and Acquisitions, and Sourcing / Procurement to…
-
Flexible Date Formatting
I have discovered 27 distinct methods for formatting dates, not including variations in separators. Unfortunately, Smartsheet only offers 10 date format choices. In the IT field, aligning data with its intended use is crucial, and proper date formatting plays a significant role in multi-factor authentication. If a user…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Finding 'send' history form a row
Hi - Is there a way to see what was sent when using the function "Send" when selecting a specific row? I see the activity log notes some information, but I don't see this anywhere. Am I missing it? Is it a better practice to always CC myself to keep track of what I am sending? Thanks! SarahB
-
Print completed forms without Business Plan
Hello! I am the sole Smartsheet user in my company (I'm trying to bring them along, but so far I haven't gotten with the right decision-maker). The main reason I use this at this time is for training and in-service acknowledgments. I used Smartsheet at the enterprise level with a previous company and convinced my current…
-
How to at mention a specific slack account in a channel from automated workflow?
I just set up my workflow so that when a predecessor task is complete, it sends an alert on my team's slack channel. The intent of the notification is to alert the {{Assigned To}} team member that they can start their assigned task. Is there a way to @mention the team member specifically using their slack account name? I…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Solution Spotlight- Healthcare Capitol Construction Demo
Hello all! Our Commercial Solution Engineering Team is hosting a demo of a capitol construction solution on June 25th at 11am PST. Here is the published Smartsheet Dashboard if you are interested in registering! If you can't make it, but still register, we can send out the recording. We also have a special guest, Neil…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
