Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2017 Posts
Archives for May 2017
Discussion List
create dashboard
Hi sir I am new user o smartsheet and i have a quiry .. please help me
Hyperlinks to other sheets not showing
Hi, anyone experienced this? I have a master sheet with a column that contains all the hyperlinks to the subsidiary sheets. The links have gone overnight! Cell history shows they were updated by a cell link user, but the cells aren't linked.... The link still exists if you double click on a cell it shows the correct link…
Currency Options does not include PLN (Poland Zloty)
To The all-knowing, How do I condition a column to allow for currency PLN, when PLN does not appear in the currency option list? Thanks, Si.
Max number of entries in drop down list?
Hi; Is there a limit to the number of entries in a drop down list? Would a list of 1200-1500 names have an impact on performance? We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the list). Are there best practices for a task like this? Thanks in advance, Andrew
Soooooo Lost - Cant Figure Out A Formula
Hey Everyone, So glad I found this community! I am currently trying to create a formula and am struggling severely with it! :( I have multiple tasks that need to be performed. Task 1 may take X days, once its finished and only once its finished then Task 2 can begin and will take X amount of days and so on for multiple…
Are Unique IDs for Columns, Cells, etc. truly unique?
Simple, but important question when dealing with the API. Are the ID's for each column, row, and sheet unique across all workspaces or are they only unique relative to the environment they are in?
Receiving Sign Off / Approval
Fellow Smartsheeters We have a process that necessitates the approval of certain managers at certain gates during the process. What is the most robust way that you have found to ensure approval is received and not just ticked off 'accidentally' i.e. is it possible to assign a column to one person only? any ideas welcome,…
Parent and Sub Parents not rolling up
Hi, I am just evaluating smartsheet and have just pulled togeather a test project sheet and I am noticing that the Parent and Sub Parents are not rolling up in the Project Duration column Please see snapshot below Regards Cathy
Groups and workspace sharing
Hi. 2 similar situations: 1) I created a group with 2 users (me and one other licensed user) then I created a new workspace and shared it with that group (editor - can share) but now I can create sheets within the workspace but he cannot (although he sees the one I create) :-/ 2) One other difficulty I have with another…
SUMIF using dates
I'm trying to use the SUMIF function to calculate the total in Column A when the date in Column B is less than or equal to 10/2/17, but haven't been able to make it work. Please advise.