-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
-
Incorrect results extracting date from system Created (Date) column
I have a system column of Created (Date). This is [Snapshot Date/Time] in the screenshot below. I need another column that should reflect the DATE part of the system column. I am getting unexpected results in the date-only column. In the attached screenshot - you can see for both 4/21 and 4/22, the formula returns 4/22.…
-
Trying to identify cells in ALL CAPS vs Title Caps
I have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?
-
COUNTIFS with 3 criterias
Hello all, I'm in need of writing a formula that takes into consideration 3 rows but one of them has values for which I do not care for. So I have Status (Complete, In Progress, Cancelled, Deferred), I have my second criteria which is a Yes/No column and I have my third criteria of values such as Blue, Red, Yellow. My…
-
Parent Row Update Based on Children
I want to update the parent row of status based on the children. If all are completed, then completed If any are in progress, then in progress if none are started then not started The below formula generally works but it has couple of issues: 1) When I convert it to the column formula, then I cannot change the children…
-
Workflows and Conditions
Hello, I have a data collection sheet that stores a variety of sites data. I will do my best to explain the setup, as well as desired outcome. This sheet contains two forms, (1) a data collection form used for new sites [requires 3 Point of Contact (POC) emails, site name, and various other fields that will not be…
-
Rows Weighted Differently for % Complete of Parent Task
We have a bunch of tasks in our smart sheet timeline that are weighted differently to determine the percent complete of a parent task. Am I somehow able to say that row 5 is only 20% of the parent task, but row 6 is 40% of the parent task, and have that calculate towards the total percent complete of the parent task…
-
Using COUNTIFS to automatically assign new rows to a person based off criteria
Hey all, I am working on a way to automatically assign newly added rows to a sheet based off a certain criteria. We have two managers. I'd like new rows to automatically assign to one manager then the other based off different scopes of work from a multi-select column. For example, I can only input 8 types of jobs and 8…
-
Sheet summaries OVERALL average
I was able to resolve a #DIVIDE BY ZERO Error message by using this formula =IFERROR(COUNTIFS(I:I, 1, C:C, 1) / COUNT(Hinge:Hinge), 0). However, I am currently hitting a road block on getting an accurate average from my sheet summaries. Is there a way to get an average of all summaries not labeled OVERALL that will only…
-
Adding an IF statement to a formula
I'm using the formula below to subtract numbers in two columns and provide the answer in a third. Some of the cells in the first column don't have numbers (there are words) so I am getting an #INVALID OPERATION error which I expected. I want to add an IF statement to the formula to return "0" in place of that error (not…