-
Cell value if there is an attachment?
I would like to add a cell that will show certain text if there is an attachment to each row, is this possible?
-
Resource Management
Does anyone have ideas on how to use smartsheet for resource management?
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Autonumber refresh for new year
I use a formatted autonumber column to record a new Reference Number for each new entry in a Smartsheet. The format I use is CR{YY}.000 where 000 started from 001 for the year 2016. I want to continue this format into 2017, but I want the 000 to restart from 001. Any thoughts ? My list of rows should end up like : CR16.001…
-
Change the size of Harvey Balls
Hi SS Users! Just wondering if there is a way to increase the size of my harvey balls? I have a sheet being pulled into a report, and then being displayed into a Sight. The harvey ball appears on the Sight, but looks ridiculous becuase it is soooo small. Is there a way to increase its size? Ive tried to change it in both…
-
Month Count/Summary as Integer
I have looked for examples but can not find - apologies for basic formula question. From a date field i would like a formula that will take the month and total/count by month: Eg: Month 1 - Total 15 Month 2 - Total 9 to Month 12 - Total 0 Can anyone help? many thanks Chris
-
VERY minor bug: deleted column with filter
When deleting the last column that is part of the current filtered view, the results show an incorrect story: Note that before the filter, there was 1 of 492 rows that met the filter conditions, so it isn't just that the information was not cleared. It was updated, albeit incorrectly. The 432 displayed is not consistent…
-
Exclude Weekends
I am trying to take a Due Date that has multiple tasks associated with it and create a Task Due Date based off the due date using a duration, but excluding weekends. For example, the Due Date is on a Monday, but the task needs to be completed 1 day before, which is a Sunday, so I need to date to populate to the Friday…
-
New discussion does not auto-follow
After submission, the discussion was not being followed. I did not notice this until I checked why no one had responded to my new discussions from last week. They had, but I was not following the thread. I know there has been some work on the Community recently based on some different behaviors. This looks like a new bug.…
-
Search functionality - returning matches on subset of a search string. Also, wild card usage is non
It appears that Search is not working correctly. Please review the Search functionality and also the use of wild cards. 1) The search results will include matches to the full search string but also to any 3+ characters within that string. For example: A search for beets would return a results list that would include beets…
