-
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),…
-
Card View Calculated Value
Hi All, In the iOS app for card view, there is an option to display a "Calculated Value" from a selected field and you can choose SUM, AVG, MIN, MAX. I don't see if this option in the desktop web client. Is it missing or I am I just not able to locate it?
-
Keep grid view as default, but save out a card view version
Is it possible to save a card view out of a sheet, but maintain the grid view version as the primary? OR save a running duplicate of the same sheet to have one as grid and the other card? IF that is not possible, what is the best alternate?
-
What happened to the task counter functionality? (e.g. 2/3 complete)
When in card view, my sheets are no longer showing me a count of how many tasks are checked off. It should be "5/6":
-
Subtask Summary not Updating in Card View?
In Card View, my Subtask checkboxes do not tally at the bottom of the card (Full View, closed card). This is a new development. Any thoughts to help? Thanks!
-
Is there a way in Card View to change a task to be a sub-task?
These tasks have a lot of data and have auto-numbering. I was hoping I could drop a card onto another to make it a sub-task or use a menu to make it a sub-task but not yet found anything. There are so many cards involved that it would be time-consuming to rewrite each one as a sub-task. Any suggestions? Thank you, Angie
-
Can I Create A Default Card?
I would like to create a default card to use for every project. Can I do this?
-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
