-
Submitting Multiple Rows using one Smartsheet Form
We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order Number and the Order…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Report view and permissions
Is there a workaround to allow colleagues to view and edit cell data(non licensed)and interact within reports created from a master data sheet, without having permission to view the master source sheet? The report is created to only include columns and rows that do not contain sensitive or confidential data contained in…
-
Form where a signature can be added
Hi, my boss would like to create a form that would be sent to an employee when they make an error. The employee would review the document and then need to sign it. Like a Doc Sign document/form. Is that possible or does anyone have a work around suggestion. Thank you Raelyn
-
extending a sum formula
Hello, I have to update a lot of sheets so that they will be ready for 2020, and i need to write a lot of sums formula, because if i expand them normally, the first one is SUM([revenue]13:[revenue]16) then the second one becomes SUM([revenue]14:[revenue]17) then SUM([revenue]15:[revenue]18) etc. But i dont want the same…
-
Card view sub tasks, can't see sub tasks of sub tasks
Card view is excellent, so good, was about to run my whole company of it!, however I have hit a snag – In card view you can view level one and its subtasks – good, however I now cannot see the subtask of a subtask, you cannot even see if there is another level below. Ok so you go to view all levels, which is fine but you…
-
Card View Conversations
What am i missing, Card view is a superb feature of SS and starting to use lots, however when you add a task or subtask there is not an option to start a conversation, you have to go back to grid view for this. further more where there is a conversation in grid view the conversation box comes up when you open in card view…
-
cannot open smart sheet folder "careline 27/08/2019"
got error smartsheet. Already log out & log in but same error. other smart sheet folder can open. only for folder "careline 27/08/2019" cannot. can refer attachment below. Please advise? .
-
An Error has occurred in Smartsheet
Dear Smartsheet team, One of our main production management sheets cannot be accessed. We logged out, logged in, restarted browser, cleared cache, computer, etc. The message is: An Error has occurred in Smartsheet It can not be accessed by web or mobile device across all our users. Please help urgently, our daily…
-
Smartsheet have Error
Dear Smartsheet team, One of our main project management sheets cannot be accessed. We logged out, logged in, restarted browser, computer, etc. The message is: An unexpected error has occurred. Error code 51 It can not be accessed by web or mobile device. Please help urgently, all our daily client projects are managed here…
