-
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
-
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…
-
Dashboard card view
Hi, On I have sheet on my dashboard. I would like it to be viewd in CARD VIEW mode by default. Ufortunately every time I refresh the dashboard it has GRID VIEW. Is it possible to work it out?
-
Grouping Rows
Hello, I have created a smartsheet update tracker, in the format shown in the screenshot below. The separate teams provide their updates in the nested row of the spreadsheet. There are also many formulas on the sheet. I would like to sort these rows from time to time so they can display in progress projects at the top,…
-
Is there a way to get the name of a sheet?
I could not seem to find this anywhere, maybe I just missed it. Is there a way to get the name of the current sheet in a cell? In other words I would like use the name of the sheet so I can parse it for a vlookup.