Discussion List
Formula to pull the current auth level based on the most recent "date from" in each grouping?
I would like to collect the current Auth level into another sheet using the Name as the identifier (what formula would look at the parent and child rows together to determine the current auth for each person?) Any help would be much appreciated. Thank you
Saving files attached to Smartsheet rows out to Sharepoint folder
What is the easiest way to take files attached to each row in a Smartsheet and save those files out to a sharepoint folder? I know you can download them all and then go to SP and attach them, but surely there exists an automated way to move the files without ever personally touching them. Bonus if I can do it when a…
How to find folder id for existing smartsheet
All, I am trying to create and maintain a bunch of smartsheets using the API. I would like to find an existing smartsheet to use as a template and create new smartsheets based on the source sheet and in the same folder as the source sheet. I have code to locate the source smartsheet as shown below. I can find the sheet no…
Merging Duplicate Idea Posts
This discussion was created from comments split from: FAQs and Guidelines for posting Product Feedback Ideas.
Max number pulled from the ID
Hi all, I am looking for help with creating a formula which would give me the max number (based on condition) from combined ID? Example of ID's RTR_I_053 TPM_I_012 FTS_F_009 The condition would be if the ID contains example "_F_", give me the highest number for this item. I tried =IF({Ref to ID column}, CONTAINS("_F_",…
Value labels on charts - font size and location adjustment
The current formatting of value labels on charts shown in a Dashboard is very clunky. The current positioning above the data segment can be confusing as overlays others. The size of the font can also look unprofessional when redu cing the size of the chart on the dashboard. Can we have the ability to change the size, type…
Smartsheet Automation Run Workflow Option Not Available for Hourly, Daily or Weekly
I am using the Automation Template "Copy a row to another sheet when specified criteria are met". Can this be enabled and enhanced? Below is what I am looking for. A) Minute and # of Minutes (e.g., Run Workflow every 10 minutes) B) Hour and # of Hours (e.g., Run Workflow every 2 hours)
Unable to get the formula correct to merge my data from multiple columns into one column.
Add days to a date. Formula help
This discussion was created from comments split from: Can't add days to a Date.
"Hello SmartSheet Community. I am trying to capture weekly data amounts based on specific date range
"Hello SmartSheet Community. I am trying to capture weekly data amounts based on specific date range referencing another sheet. I thought this formula would work but keep getting back an error. =COUNTIFS({ACF Conferencing Request Assigned Host and Tech}, CONTAINS("Alexander Tsehay", @cell), {ACF Conferencing Request Date},…