-
Reset auto number column
Hi All, I am not able to reset my auto number column recently. I followed the instruction at the bottom of the page:https://help.smartsheet.com/articles/1108408-auto-numbering-rows#create But it no longer works. I did it before, but not sure what changed. Thank you all for help Edward
-
I'm afraid this solution doesn't exist but...
I need to assign a unique identifier to jobs that we budget/bid. Since jobs tend to be budgeted/bid multiple times prior to landing the work, we want to be able to see all labor costs associated with a job throughout the life of the estimating process. The problem here is that budgets often times are requested under…
-
Hide Unhide Columns
Hi @Genevieve P., @MMcLain, Last time I checked the Community Discussions on the subject of "hide unhide" under the categories of Smartsheet Basics or Product Feedback there were 1,076 posts about the subject going back over more than 5 years. It seems like some product improvements need to be delivered in this area! While…
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Any way to stop smartsheet from adding a new blank row in table view?
We have a grid sheet that houses a bunch of information including PO#'s. We use the table view to easily search/filter the rows to find the row with whatever PO we are looking for. If there is only one row with said PO #, and we make an edit to one of the columns and hit enter, smartsheet automatically adds a new blank…
-
Nested SUMIFS / OR / WEEKNUMBER functions
Hi, how can I combine these two functions? They are both working separately for me for the same range of data. =SUMIFS({MGHours}, {MGNum}, OR(@cell = [Project Num 1]@row , @cell = [Project Num 2]@row , @cell = [Project Num 3]@row , @cell = [Project Num 4]@row )) =SUMIFS({MGHours}, {MGDate}, WEEKNUMBER(@cell ) =…
-
Primary column data to other Sheet
I have 2 sheets, Sheet A has Primary column and I want to copy Sheet A primary column to sheet B. Sheet A has 2000 lines in primary column also whenever I update Sheet A primary column I need it should be updated in Sheet B too. how I can do this in Smartsheet?
-
Unable to remove user available in a SmartSheed Contacts list
I created a Contacts list column that additionally had 4 people including myself. I then created a record as an example, using my name. Subsequently I deleted my name from the list and changed it to only allow the available people in the list to be selected. Now I do not show up in the column properties list but still show…
-
INDEX COLLECT give #INVALID VALUE error but INDEX MATCH does not
INDEX COLLECT gives me an #INVALID VALUE error =INDEX(COLLECT({event-25}, {date-25}, Day@row , {ID-25}, [Employee ID]@row ), 1) ========= But using the same reference for INDEX MATCH does not =INDEX({event-25}, MATCH(Day@row , {date-25}, 0)) or this =INDEX({event-25}, MATCH([Employee ID]@row , {id-25}, 0)) ========= I need…
-
What are the limits using Table View
I'm having an issue with Table View in that a sheet with 498,000 cells will not add a new column into the sheet. Theoretically, this will push the sheet to about 510,000 cells. I was under the impression that Table View has a capacity of 1M cells. What are the actual upper limits for Table View, columns, rows and total…