-
How to display Name of the user who created record?
Created By displays email. How can I display the actual Name of the user who submitted record through form?
-
Automating a Roll up for RYG Symbols for Health
Team, Thank you for your patience, I'm still learning. I have gone down a rabbit hole trying to figure out how to roll up Health symbols RGY. In my search for help I came across this formula but it's not working. =IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow",…
-
Another Nested IF Formula
Could use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biologics", "ASD", IF([Business Unit]@row = "Western", "ASD", IF([Business Unit]@row = "Simple…
-
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…