Best Of
Re: Stacked Bar Graph - Reflect 3 columns
I have a similar situation. I'm trying to compare how many of a specific type of requests are fulfilled each quarter, via different methods and by different individuals. Here is an example of what I'm talking about. I wouldn't mind a stacked bar chart, or one that is broken down by each person.
Chris Holt
NEW! Forms minor updates and enhancements
Hi Community!
We’ve released a few minor fixes and enhancements to forms.
Removed scroll on number inputs - While ensuring input remains restricted to valid numbers, a form will now scroll seamlessly, even if the cursor is positioned over a number field, preventing unintended adjustments to data (including accidental negative numbers).
Applied currency formatting to form entries with decimals - Now, when you input decimal values into fields with currency formatting—regardless of whether they have form validation or not—your values will automatically format as currency on both web and mobile platforms. This means whether you enter "2", "2.00", or "2.25", the system intelligently formats these entries as currency, ensuring consistency and clarity in your financial data.
Data validation in form builder - When editing a form in a small window, data validation is only applied when the user applies it, and text fields can always be changed to multi-line when no data validation is applied.
These enhancements are available on all plans.
You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Jason DelValle
Re: Nominate Peak Humans & get a badge!
In the IT PMO department we would like to nominate our IT PM Analyst @AngB789 who has taken the strides to make Smartsheet easy for project team members. She is always looking for new ways to make things easier to either find, or the biggest achievment is making approvals easier for all levels of management. User experience for those who are not project managers is a top priority for her and continues to learn and grow from the communities as well as all education provided by Smartsheet and other avenues.
ITPMO
Re: How to get attachment names from one smartsheet to another?
Hi Genevieve,
Thank you for your reply. For getting attachment names , I have written a python code to get a list of attachment names in sheet to a local CSV file.
Python Code:
import requests
import csv
# Replace with your Smartsheet API token and sheet ID
token = 'Your API access key'
sheet_id = 'Your Sheet ID'
# Get the list of attachments for all rows
url = f'https://api.smartsheet.com/2.0/sheets/{sheet_id}/attachments'
headers = {'Authorization': f'Bearer {token}'}
response = requests.get(url, headers=headers)
attachments_data = response.json()
# List to store attachment names
attachment_names = []
# Loop through attachments and collect names
for attachment in attachments_data['data']:
attachment_name = attachment.get('name')
if attachment_name:
attachment_names.append(attachment_name)
# Write attachment names to the CSV file
csv_file_path = 'Local path to your csv files'
with open(csv_file_path, 'w', newline='') as csvfile:
writer = csv.writer(csvfile)
writer.writerow(['Attachment Names'])
writer.writerows([[name] for name in attachment_names])
print(f"Attachment names saved to {csv_file_path}")
rye
Re: Fetch a value from a different sheet using Index Match or Vlookup
It would look something along the lines of
=INDEX({Source Sheet Budget Column}, MATCH([Event Column]@row, [Source Sheet Event Column}, 0))
Paul Newcome
Re: Can't Find Sheet to Set Up a Workflow
I'm having the same issue. I am the owner of the source sheet, and admin of the destination sheet. I can't see the destination sheet when I try to setup a workflow.
Does it matter that the source sheet is in a workspace and the destination sheet is in sheets?
Heald33
Mobile View
Hi Our site staff complete our Fire door survey and remedial sheets including photos using the Mobile view which works excellent and gives us back in the office instant information and records.
The only down side is only being able to select 9 fields in the settings.
Can this be increased.
Kind Regards
John
John Booth
Re: Ordering Folders
Hello @Jared Agee,
Folders by default will be at the top of your Workspace above individual assets (but they will alphabetized with respect to other folders).
If you want these out of your way you could make an admin workspace and name z_Admin to get it out of your way (workspaces are also alphabetized).
Randomly related to this is this Sheet I made which shows the sort order of symbols.
Hope that helps!
Re: Is there a way to share a dynamic view with someone who does not have a Smartsheet account?
@Andrée Starå Do you know if this has been done and if its possible? I have the same need?
ChristineMesa
