-
Gridview to Dashboard
I am collecting data on hundreds of IDs that are designated by the primary column in grid view. Data is added as additional columns. I'd like to be able to condense the data for each ID, e.g. using a dashboard and 'card view', but I can't figure out how to do this without having to manually create the dashboard for each…
-
Remove Field Header in Card View
Is it possible to remove the column header for selected columns in Card View? For example, I have a column that has a hyperlink to project stuff; project plan, a project folder for docs, project mailer. I do not need to see the header in Card View when the hyperlink is the same thing (screenshot attached). I recall not…
-
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
Hiding view in card view
Hi Their i have a card view where i want my staff to enter in certain information, i want to be able to add some cells with some formulas that DO NOT appear on the card view but are viewable or present in the grid view. for example i have a formula that will check a box when a card has not been updated which in turn sends…
-
Highlight Recently Modified Fields
Is it possible to create a condition that highlights only those fields that have been modified within a specific date range? I would like the highlighting to appear the way the notification email exclusively highlights new or changed fields.
-
VLOOKUP and Conditional Formatting
I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its due date no longer works on the VLOOKUP cells Is there something I'm doing wrong? Or is this a limitation of the software? Has…
-
Summary Row Card View
Hello, I cannot find any resources showing how to create a summary row card in card view. My lanes are based on stages of a project which is selected through a drop down on each row. I would like to total the NPV of each project that is in that stage (NPV is one of the columns in my sheet). How do I do this? Thanks!
-
Resource Management
Hey Guys, unsure if this is possible but lets see. I am going to be using card view as a kanban style work stream for my team, each card will have an estimated effort as to how long the job will take and an actual field for the actual time. each of my staff i could say has 5 hours a day free. what i am trying to achieve is…
-
Keeping Parent Card / Subtask relationship when moving card to another sheet.
Hello everyone. I was wondering if there is a way to keep the relationship between a parent card and its subtask intact when moving a sub-task between sheets. In our case this would be various departments who are assigned a sub-task then the card is moved to that departments board. When complete, the department would move…
