Discussion List
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
Control Center - Global Updates - Dashboard - Error
I would like to update Dashboards based on updated Blueprint. There is the error message "Failed to overwrite sight. Error (4000) durint the test update run. I haven't done much changes to the dashboard. Can anybody please help. Thanks a lot
Creating a sheet from and excel?
I am trying to create a new sheet from and existing excel. I get an error in Smartsheet saying, " The Microsoft Excel file "Solution Requirement matrix.xlsx" that you are attempting to import appears to be invalid." Can anyone tell me how I can create a sheet from an excel?
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)