-
How to use contains properly?
I am trying to use COUNTIF to check a box. The formula im looking to write would look at my column, "PO #" in sheet 1 and check the "PO" column in a sheet 2 and see if it contains the same number from sheet 1. below is my current formula. I dont get an error but it is not producing the expected result. i have a number of…
-
Auto-Rescheduling Tasks (Based On Tasks Being Dragged)
Please see attached screenshot on just a draft option on what I am playing around with. I want to drag Task 4 to actually be Number 1 priority and for that Task to be completed 1st (however I don't want to use the Dependencies feature as the tasks are NOT linked, they are all separate) and I want the dates to all change…
-
Regions Implementation parity with US instance
Hi Please could you bring the EU region up to the same standard for connectors, comments and functionality such as add-on, email reply to comment, and everything else that we are missing out on. The Regions capability on the site is not complete and I can see many people wasting time and energy only to find out that it was…
-
Older templates no longer accessible
Hi I'm on a Pro account, after my organisation downgraded its Enterprise account in May and I wanted to continue using Smartsheet. I've been a user of Smartsheet for over 10 years. However, recently I've noticed that I'm getting an error message when I try to use the older templates (see below). Does anyone know why this…
-
Row Report - Column Summary but also need an average
Hello- I have a Row Report - with column summaries- I've attached a snippet of the Row Report to show an example. The column totals are at the top. And for example, in the 2nd & 3rd columns it's listed as Ind #1 Expected & Ind #1 Completed - so the total is 50/53 but I was wondering if there is a way to also get the…
-
Help with Moving Line Data
Hi, I need my Line 1, 2, 3, etc to go to bottom (descending) but i don't have dates associated. Is there a way to do this easily enough? New to SmartSheets.
-
Refresh list of sheets to link to
I am creating lots of sheets that I need to link to master sheet. Each time I create a new one, when I go to the master sheet and click "link from cell in other sheet", the newest sheets are not showing in the list and there doesn't seem to be a way to refresh the list; instead, I have to refresh the whole page, which…
-
How to assign values to drop-down menu options and sum them up?
This discussion was created from comments split from: How to assign values to drop-down menu options and add them up?.
-
Row-wise Reports of Sheet Summary data
Hi It would look much more elegant if the sheet summary cells in Smartsheet reports could be displayed in a row-by-row format, rather than just the current column-only layout. I feel this vertical arrangement, as shown in the attached sample image, would create a cleaner and more appealing presentation.
-
Trying to send information from another website to the SmartSheet API
I have been trying to send information to Smartsheet through the API. I can get records to view, however, when I go to post a new record, I get a 200 Success message, but, no data was transferred. I have reviewed the API Documentation and I was testing on the 13th and noticed on the 16th a bunch of rows added that were not…