Hello! I am new to Smartsheets and am trying to build a Summary Report based on drop down selections and data from various sheets. I have a TON of data and too many cells so I've had to spread it out on a sheet per month. I have two drop down selections. One is to select the month and the other is to select a division…
I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn the Status Column drop down to red. Once the Status Column drop down is changed to green…
An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise account.
How can I get sheets to remain in the workspace/folder when bulk transferring a user's sheets to someone else?
Hi everyone, someone on my team brought this to my attention and i want to see if anyone else has experienced this. I have a sheet where the 90% of the data is entered via a form. the remaining 10% of data is filled in afterwards once some additional information is received. my team member says that he is 1000% certain he…
How do I formulate a percentage in cell "Total Percentage" using division formula based on data from "Total Score" cell? The "Total Score" cell correctly shows a result of 43. What I want to do is divide that number (43) by 50 with the end result of 86% displaying within another cell called "Total Percentage." Total Score…
Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell. =JOIN([Comments #1]1:[Comments #2]1:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1,…
Is it possible to pre-populate a dropdown field in a form with a query string value when the values of the dropdown field are set to contact list and have a pre-defined set of people?
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
Hello Community!! I am attempting to build a solution set for an internal training/learning organization who has to go build very complicated trainings for technical staff. Each agenda will contain modules.... Modules will house the table of contents for topics needing to be covered under each module. There could be a few…
