-
User download@smartsheet.com in the Activity Log
Hello community and/or Support Could not find in in the helpfile: What / who is the user download@smartsheet.com in the Activity Log (see attached screenshot) ? I first thought It is actually the user who downloads the attachment, but when I do this, the Activity Log is not updated whith this action. Maaik
-
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.