-
How to add a value from any row that has column = May
This sheet (displayed to users as cards) moves projects to different months for capacity planning. We then have a header task for each month which we display the total job value currently assigned to the month. This value is currently manually calculated. How/can we have a formula in the header task that sums all the $…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Why can't I update Target date in card view?
Is there a way for me to edit the Target date while staying in card view? The only ways I've been able to adjust the Target date on a card is either switching to another view, or updating the Duration. Both of these alternatives are less than ideal, as they require more time and effort than simply updating my new Target…
-
Best way to display product information
I am creating a master sheet with information from several different cross functional teams, including dimensions, features, product images, product availability date, etc. We are at about 175 columns total at the moment, and as you can imagine, finding information is time consuming. I'd like for people to be able to…
-
How to remove no longer used lanes in Card View?
My sheet has named people in the contact list (the column card view is sorted by) who are no longer allocated any projects on this particular sheet but they still have a lane showing with (0) next to their name. I can collapse the lane but it means I have a lot of collapsed lanes cluttering the sheet. How do I get rid of…
-
What is the definition of Uncategorized?
Hi Experts, I am a brand new Smartsheet user and this is my first visit to the community. In Card View (View by Assigned To), the left-most column is Uncategorized. I can't figure out what this column is supposed to represent. Originally I thought that it contained unassigned tasks, as many of the tasks in that column are…
-
Why a column does not appear as a selection when i press the "View By xxxxx" in Card view
When I am in Cardview I go to Card View Settings / Fields to display. I select 4 fields to display. However, they do not show up as options when I want to change the views by different columns. How do I get these items to show up after I selected them in the Card View Settings? the columns are text/number columns I am…
-
Using IF formula to reference any change in cell (adding a value)
Hello Experts! I was wondering if a formula like this is possible: =IF([Confirmation #]@row = "any value", "Confirmed") When a confirmation number is added to a cell, that means the item is confirmed. What can I put in place of "any value'? I am just not sure how to do this in the context of my larger status formula:…
-
Card View of Sheet in Portal
Is there a way to add a card view of a sheet to a portal for easy viewing?
-
Is there a way to assign a certain task/activity to multiple groups and generate report by group?
I want to use Smartsheet to track progress of task/activity by team or people. However, some tasks/activities may be assigned to multiple teams or people. For example, activity A to be done by x & y. Activity B to be done by y. Then, I want to create a report/dashboard to show all activities assigned to y (activity A & B),…
