-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
-
Add Dynamic Reference in Formula
Hi, I'm creating a summary sheet, I have a few sheets with the same columns, and I want to add COUNTIF formulas to the summary sheet, I'd like to know if there's any way that the Reference should be a dynamic option, so if a user chooses on the Reference sheet from a dropdown column: Sheet 1, the formulas knows to use…
-
How Can I Create a "Stamp" of An Original Value?
Hi - I'm trying to create a rule/process whereby every time a row gets added (not changed), another cell gets "stamped" with the value. This is so I can have the stamped column as a reference of the Original value. In my scenario, it's a Total. So a row will get added, and in that row is a Total Column. I want to create a…
-
Updating Sheets Dynamically off Master Sheet
Hi! I am trying to create a solution for one of my clients and am hitting a mental roadblock. What I'm trying to do is simply update multiple sheets based on adding a row to the Master Sheet. I don't want to use the Copy Rows function for a few reasons, and this would be something I could solve with a Report, but I can't…
-
Restricting Access to Linked Attachments?
In a sheet that I created and shared with other users, does every user have access to be able to open/view attachments linked to some rows if the user I shared the sheet with doesn't have access to the document in the original application (ie, Dropbox)? If so, is there a way to restrict access to the sheet attachments for…
-
Why has my metric sheet stopped working?
The following table counts data from a sheet using COUNTIFS functions. EG countif it a question and = the row or countif its an alternative proposal and the row. However the its stooped counting. For example there are 5 'Role specific' questions in the sheet but the table below shows 3? And there is one Alt. prp but none…
-
What function do I use to capture the highest risk rating
I have a riks register that includes a column for a rating eg critical, high, medium or low. I want to surface to another sheet/report/dashboard a summary of all risks in the risk register as 'Risk health'. My thinking is that this woudl be the highest rating of al in the register. What function would I use to determine…
-
Predecessor Logic for a Specific Day of the Week
I am working on a project plan template that has a lot of dependencies enabled for dates, and many of them need to start or end on a specific day of the week. I have searched the community and see a lot of questions on this, but do continue to see that it has not been developed as of yet. I did try to search within the…
-
Apostrophes being added in front of numbers and column property changes to dropdown (data shuttle)
When I use Data Shuttle and I upload the source to the target, it is changing column property from text/number to a dropdown and adds an apostrophe before the number. I have 8 "discount" columns per sheet, but it only disturbs some of them. If I need to perform some calculations using those numbers, I can't. I'm not sure…
-
Average for both columns
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not count. It only count the column that doesn’t have it. This is what I tried: =AVG(IF([1st Circuit Status]@row = "Assigned to…
