-
Lock a Field
I have a field with a formula in it and I want to be able to lock it so only owners and admins can edit. i cant lock the row as details have to be changed by editors in other fields in the row.
-
Cell linking from Report?
Hi all, I have a question and/or suggestion regarding cell linking. I have a master sheet that needs to pull cell links from multiple sheets which have very specific parameters. The sheets that we are pulling the cell links from all contain vast amounts of data, so we've created a report to pull the specific data that we…
-
Automatic Cell data input..Formula???
I am polling permission via web form from 150 of our top accounts. The web form will only collect client info they would know, such as their name, account name, email, contact # and yes or no for permission. However, on our end, when that entry comes in, I need other internal info to auto populate based off the "Account…
-
Cell Link Capacity
Hello, For 2019, is there any chance of the cell link capacities increasing? Does anyone have any insight to this?
-
Copy Rows Between Sheets Based on Checkbox
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The…
-
Dateformat changes in external linked sheets
I've created a table to manage our school-year. Out of this table several calendars should be created. As there is no possibility to create more than one calendar out of one tablesheet I worked with markups and created external links to some other tablesheets so that there is one sheet for every group I have to manage.…
-
Formula to count values in a column
Good evening VERY NEW to smartsheet. I am creating a metrics sheet for data we want to capture on another sheet. How do I get the QTY of "beam" counts in this column? Thank you
-
Countifs Formula using a date range given
I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date. I need to limit the data count on the metric sheet to only count if is it in between (and including) start and end dates given at any time. =COUNTIFS({Score}, "Pass", {Club}, "AAA…
-
Dynamic Data in a Drop Down List
I know you can up type in a list of values into a drop down list but can a drop down list be dynamically populated with data from another column? Can you use values in one column (column A) as input to a drop down for another column (column B) . By reading the data in column A and populating a form's drop down list in…
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
