-
User Management and GDPR
All our sheets have an assigned column which we use to assign a task to an account user. Some users have left the company and as the systems admin and licensed user, I have deleted their user accounts. They were not shared into any groups and were all unlicensed users. We have a business level account with Smartsheet. We…
-
Dependency of tasks in gantt
Hallo together, hope you can help me with this: How would it be possible to create dependencies of tasks, meaning: you cannot start with a task if another task is not done, f.e. you cannot start assigning the electrician before the room has not been constructed - right ;-) Any solution ? ;-)
-
top 10 list showing both count and name
I have a row that contains user names and then a second row that contains counts associated with each user name. I want to be able to look at these two rows and create a top 10 list that shows the top 10 counts as well as the user names associated with these top 10 counts. I have the formula for getting the top 10 counts…
-
I would like to have my formula simplify. I am not great with adding and/or to my formulas.
=COUNTIFS({COLLECT PLANT EXHANGE TEMPLATE ENTER STUDY}, [STUDY NUMBER]@row, {COLLECT PLANT EXHANGE TEMPLATE ROOM}, [ALL COPY]@row, {COLLECT PLANT EXHANGE TEMPLATE Range 5}, [REF DATE]@row, {COLLECT PLANT EXHANGE TEMPLATE TYPE 1}, [TYPE OF PLANT 3]@row) + COUNTIFS({COLLECT PLANT EXHANGE TEMPLATE ENTER STUDY}, [STUDY…
-
Formula for a checkbox
Ok so what I am trying to do is put a formula in the background of a checkbox. The purpose is the have the formula check a name in a cell, and then compare that value with a list on another sheet. At the moment I have that list typed one name per cell vertically however I would prefer to be able to put the list into a…
-
conditional formatting not working
I'm trying to make my conditional formatting work so that a column is highlighted a specific color is the % Completed column is over a certain amount and the Due Date is in the next 7 days. I even moved this rule close to the top of the list, just to make sure this would work. Can anyone help me fix this?
-
Absolute Reference
I am working on creating a formula that hides behind a checkbox. I have the formula working where it checks a value in a cell and then checks to see if that value exists in a list on another page and if it doesn't it checks the box Just having issues with the formula disappearing if I manually untick the box. What I can't…
-
Convert Text into a Symbol
Hi All, I am having great difficulty with what I think is a fairly straightforward formula (One of those days I think!). I have a basic Smartsheet containing two numbers. If one number is higher than the other or vice versa I want to bring in a Symbol pointing either up/down. I know the text to show a symbol is up, down,…
-
Using COUNTIFS with CONTAINS
Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True") The return value that I get is "0," which…
-
Work Insights - column not available to select
I have a column in a sheet that uses a formula (If this field is not blank then status is "Complete"). However, on Work Insights, this column is not available to select. Why?