-
Can an intake form populate more than just a new horizontal row in a sheet?
I have timeline templates built out in a cascading fashion (with parent and children relationships) using "workday" formulas and a holiday list. I'd like to start the timeline off with an intake form. The customer would enter the timeline type (telling smartsheet which template to pull) and then the start and end date of a…
-
Full sheet daily backup
Hello, There are several asking has a complete sheet backup feature been implemented since this post? The post is a 2018. We are looking for a solution where the sheet itself is backed up and can be retrieved with all attachments, comments and conditional formatting restored to it's backed up form. Thank you.
-
How to populate dropdown value list from another sheet
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use to select which employee this record pertains to. Help? Thanks!
-
Parents Misrepresenting Start & Finish Dates of Children
I have the Parent Rollup Functionality turned on as it is essential for my project to handle to dependencies. The problem I'm trying to overcome is that the Parent displays Target Start (TS) and Target Finish (TF) dates when not all children are populated in the same fields. If child#1 (of 2) has TS and TF dates populated,…
-
How to if statement for more than one cell ?
How to if statement for more than one cell ? What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell
-
Using the ,21 (ISO) option when determining WEEKNUMBER - Sheet displays ok, Report doesn't
Hi, When using this formula to return a week number =IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row, 21)) the correct week number value displays accurately in the sheet which is good. However, the Report fails to display the column value and displays #INCORRECT ARGUMENT SET Removing the ,21 parameter and…
-
Sheet Overview/Screenshot in Dashboards
Hello, I'd like to create a dashboard for my team where we can see information from multiple sheets at once. These are normal grid sheets, not reports. Is there a way to do this using the dashboard feature? Appreciate any guidance. Thank you, McKenna
-
Invoice & Budget Tracking for Construction Projects - using Attachments
This is an easy way to keep track of your invoices
-
Best Practices for Browser Zoom - HOW TO TURN THE ALERT OFF??
I know there may be some row alignment or auto-scrolling issues if my browser zoom is set <90% but these things wouldn't impact what I'm doing 90% of the time; however, the message at the top of my screen is relentless and disruptive. Aside from fixing zoom %, does anyone know how to prevent this alert from alerting?…
-
Using Logic to Autofill Other Fields in a Form
I have a form where a user would select options from a drop down. Ideally, like to setup logic so that when they select option D, there is another form field (let's just call it Field 2) that is then hidden and has its value set. There are other times when if they were to chose Option C, they would need to decide what…
