Is there any way I can view the cards showing only the columns with data from the grid view? For example i have about 20 columns on the grid view, and i would like a rule so that when i look in card view only the populated cells appear.
Hi I created a bunch of sub-tasks and when I tag people in the comments and they get the email, when they click on "open in smartsheets", they get this error: "This card is not visible in card view because it is empty" Any idea what is causing this? Thanks!
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
Hi, I have setup a workflow around an "Update Request" but the one field that I would like them to be able to update does not allow it. I have checked that the field is not locked as well. I have attached a snap shot of both the workflow and how the form comes through. What am I doing wrong?
I am currently working on creating some sort of link or equation, that could allow me to create a "directory" sheet where the names in the primary column could be linked to another sheet so that all the names would automatically become options in a drop-down box for another sheet. Is this possible at all, or is this a…
Hello, I hope you can help please. We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week. I have written an IF AND to use a red indicator if the conditions above exist and green if not. It seems to work…
Hi, I am using smartsheet to administer small grants and organise the adjudicators. The dashboard is great because I can include the adjudicating instructions in one widget so it's easy to refer to whilst judging. What I was wondering is if there is some way of embedding the update request form into a dashboard. I can send…
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
Is there a way to push projects from SmartSheets to Podio?
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…