Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2017 Posts
Archives for November 2017
Discussion List
Formula DATE & IF
Hi, I have a sheet that I use for accounts. I have a column for Invoice Date, a column for Due Date and a column for Status. I would like a formula for the status column to read "due in X days" ( a countdown of sorts) if invoice and due date same, read "Today" and once the due date is in the past, I would like the status…
Linked Cells hindering form entries
Hi, Facing a problem with form entries on sheet with a bunch of empty linked cells. The webform entries go right to the bottom where the links end. The linked cells are important as plenty of info will be added to it in a single day and it becomes quite cumbersome to keep adding new links as we go. Is there a workaround…
Limit to the number of Smartsheets linked to one JIRA board?
Hi guys. I am setting up a workflow where a bunch of Smartsheets, each representing a different project, feed into one big JIRA board. Each Connector workflow has a JIRA filter that makes sure only the issues associated with a given Smartsheet get synced back, so every JIRA ticket is ONLY linked to one Smartsheet row (I…
Third Party Forms Capabilities
Is there a way to use third part forms to populate smartsheets? Basically I need a form that allows for multiple row entries per form, but I know that is outside of smartsheet forms current capabilities. So if I find a third party form system that allows it, is there a way to link it up with smartsheets? Thank you, Joshua
Notification/Reminder for Past Due Task
I have reviewed the many questions asked previously by others regarding Notifications and Reminders as relating to dates and I am either not understanding them or they are different enough from my application that I don't feel the solution is applicable. I am simply attempting to send an e-mail to an individual whenever a…
Can I see what resources are assigned to from resource view?
I have a resource listed as 300% utilised on a reasonably large project. I'd rather expected resource view to let me click and list the tasks in question, but it only shows the project(s) involved. Despite the various card/project/etc views I also cannot see an obvious "who is doing what today?" report - I can see what is…
Autofill Date Column with Conditional Formatting
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. Can anyone help me with this formula? Thank you
Card View by Progress and assigned to category
Is it possible to setup Card View like a Kanban board that has 3 status columns (Not started, In Progress and Complete) and multiple row swimlanes (based on assigned to category). Thx
Formulas: Countif / And / Children Rows
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "risk level" columns? I'm trying to avoid a "messy" formula but I'm receiving an error through all my attempts.
Form data
I created a form. Sent the form link to my email address. Received it. Populated and submitted the form. Received the confirmation email. The data on the populated, submitted form do not appear in the SmartSheet. Can anyone explain how I activate or enable the data in the form to download to the corresponding SmartSheet?