Sheets
Discussion List
-
When can we expect an expanded color palette for Sheets?In Using SmartsheetCurrently in Sheets for background fill and fonts, there is only the option of 5 shades of 8 basic colors as shown below. When can we expect this to be expanded to a full hex palette like for charts in Dashboards?
-
How can I convert text names to existing contacts in my account?In Using SmartsheetI manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed…
-
How do I create a report that sums totals from my sheet?In Using SmartsheetHi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.Answered - Pending Review 950 views 3 comments 0 points Most recent by Bassam Khalil Using Smartsheet
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …
-
Problem to move infos from one sheet to an anotherIn Using SmartsheetI have a problem with my Smartsheet sheets. I made a mistake and instead of copying datas from one sheet to an another, i have transferred datas from one to the other sheets. After this manipulation, I deleted a lot of info in the new shee…
-
Smartsheet webhook subscope weird behaviorIn API & DevelopersI have a sheet on smartsheet that looks like this: I wish that when `test_trigger` column in the sheet got changed, smartsheet can send a notification to my AWS API gateway. So I use webhook with subscope to setup the notification. How…
-
Calculate Reverse Date FormatIn Formulas and FunctionsHi dears if someone can help with this format I have 3 cells: 1-ESTIMATED REQUIRED DELIVERY DATE: include the estimated date of delivery 2-PROCUREMENT TIMELINE: autogenerated including the number of working days 3-PR ESTIMATED SUBMISSION D…
-
#INVALID Ref in metrics sheetsIn Formulas and FunctionsMetrics were working fine until today then the above appears in place of all formulas = dashboard not working too
-
How do I cusomize system generated date created?In Formulas and FunctionsThis generates a date and a time. How do I customize so I just get the date. I can then use a formula to count across a date range. I cant if thee is a time in the cell too.Answered - Pending Review 13 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
How to build a report that will count different criteria from a column?In Using SmartsheetI have a dropdown multi-select column in my sheet. It can be seen below: I want to be able to build a report in Smartsheet that will be able to tell me the count of each different category. For example, a count of all the clients that sel…
