-
Kanban View - printing or saving to PDF
In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
-
Start and end date line chart
Hi Team, Can anyone help me how can I create a line chart based on below information. I
-
If and Find
If cell A3 contains "ABC" then enter "ABC" in cell A1. Can someone help me do this in smartsheet? I tried using =If(find("ABC",A3,)="ABC","ABC","X") but its not working. Thank you
-
Update Columns in Existing Row Using Forms
Hello, I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each row is auto-numbered for tracking. Is there a method for a form or process to create…
-
Dependency Logic based on one or the other predecessor tasks
Is is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific project. IF a permit is required then the rest of the schedule should be based on the…
-
Rows will not stay in place. NEED HELP NOW
We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the priority of projects. Recently, the information in the sheet began jumping randomly…
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)
Hi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.). For my source sheet, I'm using a repair and…
-
Howto Save a Filter with a Column of data that is Summarized
I use Smartsheet to track construction jobs in columns listed by Type of Job, Year, Contract Amount and other characteristics. Filters have been created to display jobs by - specific type of work involved - year of bid submitted - status of bid I am able to summarize the filtered column for the Contract Amount but am…
-
Do you use custom branding for your Smartsheet account or Workspaces? We’d love to get your feedback
Hi there! Does your team get excited about custom branding? Our team of UX researchers would love to chat with you. We are looking for people to join a 20 minute feedback session on some updates we’re making to how custom logo and colors appear. Here are the details: People who complete an appointment will get a $50…
-
Conditional Drop-down list columns
Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list. Say…