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.
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…
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
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?
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…
If "x", and checked box y
Hello, I am trying to Check box = If column 1 ="x" and if column 2 is checked = column 3 to be checked e.g. If Column 1 contains "Street Lighting" & Quote Successful Column is checked, Street Lighting successful box is checked I've tried the following equasions =IF(AND(Team7 = "Street Lighting", (NOT(ISBLANK([Quote…
Sending Update Request
Hi, Is there a way to select more than 1 row when sending update requests? For example, I have a teacher that tutors 3 classrooms. When I filter for those students, I get 100 rows. Is there a faster way to select all of the rows for updating or do I have to select one at a time? Thank you. PM at a Virtual Charter School
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
Card view - by assigned to return Parent name only
I'd like to create a Card view by Assigned to in Compact view The card should be created only by "Parent" name and "Children" should be part of the information received when clicking the error for more details. Is is possible ?
Automated Row to bring up
Is there a way to automatically bring up rows that are in the bottom of the sheet? for ex: bunch of tasks that are live, done and on hold respectively. Is there a automated way to bring the live rows up, done rows at the bottom and on hold rows in the middle? I can do this with a report but was just wondering if I can…