-
Card View - Data Entry (Logic & Formulas do not show up)
I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not do what they do in grid view. I have many columns to populate and the entire point was to make it easy and smart. Does…
-
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…