-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
-
How to count Checkmarks in a column
Is there any body that can help me with - how to setup " How to count Checkmarks in a column " I have a lt of columns which a need to have a total count of - In the top of the sheet or in the bottom. Thanks Søren Knudsen - Denmark
-
Formula that Automatically changes Date when cell changes
Is there a formula that would automatically change its date to reflect the date a cell or column changes? For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated the…
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying to…
-
Pivot App - Transfer of Ownership
I was wondering what would cause the, "Error! Target user doesn't have sufficient sheet/report access.", error when trying to Transfer Ownership of a Pivot Sheet, from one License to another? I own both Licenses, and they are also Business Licenses. I have previously made 20 or so transfers, but I am having trouble with…
-
Communication Between Smartsheet and SharePoint
Is it possible to automatically create a folder within sharepoint when a line item is added to smartsheet?
-
Resourcing is looking at SCC template gantts
Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects. Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt schedule options (of…
-
Setting up notifications and alerts
I am going to have a sheet made for every lot that we land survey on which adds up to a lot. Each sheet I have 13 rows of tasks and 13 rows of columns, 12 of them being contacts and one of them being status of the task. I am trying to set up the notification or alert to contact those in the contact columns when the status…
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
Auto Fill a Contact Column
I need to have a contract cell automatically fill with the contact cell above it. The column type is contact list and I want the user to be able to select the contact in the first row and have the rest of the rows automatically fill with that contact.