-
Export multiple Smartsheet Reports to One Excel Workbook
Title says all. I'm trying to clean up stale data out of Smartsheets and store offline as the data is no longer relevant for stakeholders, however I want to keep a record of said data, just not in Smartsheets. This is because I need to clean up Reference Sheet connections before my two master sheets have too many…
-
Linking to both the start date and finish date of a predecessor
I have a task that can start 1 day after the predecessor task start, and will finish one day after predecessor task finish. Can I link to both the start and finish of the predecessor in one row? I'm imagining a predecessor formula that looks something like nSS +1, nFF +1 however that doesn't seem to work. The duration…
-
Convert Numbers to Text so I can show a range keeping the comma delimiters
I have two columns of data showing prices, say $1,100 in one and $2,200 in another. I want to display this as a range in a report as "Your price is $1,100 - $2,200". I used this formula: "$" + $[Report Low Price]@row + " - $" + ($[Report High Price]@row which returns "$1100 - $2200", how can i have it include the comma…
-
If you give someone access as a 'Editor - cannot share' to a sheet, does this mean they have access
I need to give one person access to a file but I don't want them the ability to have access to other folders and files within the workspace. Is this possible?
-
Proofing Download Not Working
Hello, I have a sheet with Proofing enabled. When a proof is sent to a reviewer with the allow download option enabled, the reviewer is unable to download the proof. When download is attempted, a new page opens up with an error message that says, "This link has been removed or cancelled." How can this be fixed? Thanks, Dan
-
Using Smartsheet to Propose/Review/Approve/Contract/Assign Conference sessions
Hi Team! I am in a bit of a stitch over here - my organization has been using a product called "Precis Abstract Management" for the last few years to collect conference proposals (~300 a year) and, in turn, review, approve, contract and assign times for the proposals. Today, we found out that the parent company is no…
-
Build a report that includes user input
I have a smartsheet with approx 30 parent rows and anywhere from 30-65 child rows per parent. I need to provide numerous individuals with reports for individual parent rows. Can a report be 'dynamic'? i.e., report requires input from user (preferrably by selecting from a dropdown) and then the report is generated. I…
-
MultiSelect: Export to Excel Not Useful
I have just tested the MultiSelect Function. When you export to Excel it simply concatenates the items to make a single word For example What type (s) of room could we book you into? Double Single When exporting to Excel it outputs to DoubleSingle That is no help, unless there is a delimiter in the cell, it is worthless in…
-
Counting Grand Children - Count of Children
Smartsheet Community: I am not Sure where to Put this Part of the Formula in my Existing Formula to Subtract The Children. Existing Formula: =VALUE(COUNTIF(DESCENDANTS([Test Status]@row), "Pass")) + " Passed Out Of " + VALUE(COUNTIFS(DESCENDANTS([Test Status]@row), OR(@cell = "", @cell <> ""))) Formula To Add: To Subtract…
-
Can I change a row and trigger other rows to be assigned to a person?
Hello, I'm fairly new to smartsheets, and for my work, we are building a new template to use for project management. One of our first rows is to assign a specialist to the project once one has been determined. I want to know if there is a way to select one row in specific, and once the row (any value in the row works, but…