-
Drop-down choice based on rows in another sheet
Is it possible to define the single choice column, for which possible choices are loaded from another sheet? For example, I created a nomenclature sheet for issue types. I use it to define (via VLOOKUP) a issue code prefix based on selected type. But the choice of types itself I have to type in the consumer sheet. So, when…
-
Using forms to add data to an existing row
Hello, I can see that a form will populate data into the next available row in Smartsheet. Can forms be used by other Team members to to gather and add info to pre-existing rows, governed by a specific date as an example? Regards, Richie
-
Add month to Date
Hello, Please help me why when the "C Date" is December, and the "IN Freq" value is "12 Month" I got an error "#INVALID VALUE" and it works if "C Date" is December and the "IN Freq" value is " 6 Month" with the formula below: =IF([C Date]@row = "", "", IF([IN Freq]@row = "", "", IF((MONTH([C Date]@row) + VALUE(LEFT([IN…
-
Performance issues with images in larger sheet?
I'd like to understand any risks associated with a largish sheet that has an image column. Will this affect the overall performance or create any downstream issues that I might not anticipate? I expect that it will be a moderately long sheet with about 1,000 rows growing to potentially 3,000 over time with 40-50 columns.…
-
Proofing views
When I review proofs, sometimes there's what I call a "hidden eye" and More Options (...), and sometimes there is not. I attached screenshots to show what I'm referring to. Does anyone know why it's one way or the other? Thank you in advance for any insight!
-
Update Request to a Distribution List
Automation-based Update Request that is sent to a shared email inbox by our IT team. My understanding and my previous experience has generally been that the update request is a one-time use because I’ve often forwarded or been forwarded an update request that I was unable to update. So, once one member of the IT clicks the…
-
How can I update a row's information using a form?
I have a sheet that identifies each submission by a submission number. If I use that submission number as the "matcher" how can I update the other columns in that submission number row? I created a form but it only adds rows at the top. However, my coworkers will be using this and they won't have access to the sheet so I…
-
Sending automation (alert) including an attachement
Hi, I have row with either one or two PDFs attached that the document builder just created based on the data from the row. I'd like to add an automated trigger to send the attachments to the user (contact in a column). Is there a way to just include the attachments in an alert email? Thanks, Zsolt
-
Pull data from Multiple sheets into single sheet and still allow to put formulas
Hi, I have different sheet for projects but I want some key specifics in a single sheet that could allow me to use this data later to present the billing and other related aspects of the work. Here's how it works: Project plan sheet: This contains the project plan, start dates, end dates and the %complete. For an instance…
-
Can you pull in children rows based on parent row criteria?
I am trying to filter a report based on parent row criteria but also show the children rows for the parent row. Is this possible?
