-
Project Completed If Date Entered
Hi, I am trying to extract a confirmation from a row containing dates. The objective of the following formula is to determine if a date has been entered and if so, display the number 1. If not, to Display a zero. Note, the formula works when information is not entered in to a DATE column, however when the cell is blank, it…
-
Lock Columns
Each member of my team have their own report, they all have the same columns as part of their report however, each person is in charge to update the information of only certain columns. For example, if I have 4 columns name A, B, C and D and 4 reports each of them for 4 different people that are able to see the 4 columns.…
-
Macro Functionality
Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows. My question here is as follows.…
-
IF/AND Formula
I am trying to create a formula for when two approval columns have 'Approved' in their dropdowns to change two other dropdown columns. When "APPROVAL Status - BOB" = "BOB - APPROVED" AND When "APPROVAL Status - JOEL" = "JOEL - APPROVED" THEN "Approved?" column will change to "Approved" AND "Issue Status" column will change…
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
Attachments
Is there a way to deny being able to check a box complete until an attachment is added. Thanks in advance
-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
Administration controls
Greetings, I am looking for advise. I am new to Smart sheets and my Operations manager no longer works for my company and she is setup with all of the administrative controls. I need to gain administrative control of the account. can anyone assist me in this?
-
Master Schedule
We have a a master sales information sheet that imports from our sales software and then links out to individual client sheets. Each of the the client sheets links to the previous job via cell linking and predecessors, We then have a portal that includes a gantt view of a report that we look at for scheduling - see…
-
Signed Approvals
Hello Is anybody using some form of signed approvals and how does one set it up? Do you use different apps and/or integrations etc? Regards