-
Error Message on Sub Tasks
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!
-
Auto Populate second sheet
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…
-
Working with an update request workflow
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?
-
Auto-populating between two sheets
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…
-
IF AND date issue
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…
-
Embed an update request form on a dashboard?
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…
-
Scrolling with a mouse wheel
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.
-
Podio and SmartSheet
Is there a way to push projects from SmartSheets to Podio?
-
Using COUNTIFs with FIND & AND
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…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…