-
Smartsheet assistance.
@Genevieve P. I hope you are well? I haven't message in the forum for a while as my Smartsheet has expired and it has taken me a while to get a license. I was wondering if you can assist with a issue I am having with a project I am working on. I am creating a timesheet form and I require some sort of automation or…
-
Smartsheet assistance.
I was wondering if you can assist with a issue I am having with a project I am working on. I am creating a timesheet form and I require some sort of automation or something similar. In my sheet I require if one cell is change it populate another cell with something that is already logged elsewhere. for example in my sheet…
-
Formulas with Drop-down Multi-Select Column
Hi there! I have been using the new functionality of the "Drop-down Multi-select" column and I am trying to capture all of the different combinations that can be selected within the column. The column is supposed to capture the root cause of an issue and the person working on the issue is able to select multiple root…
-
Report with the last entry to each person's forms
Hi! I need to know how I can make a report with last entry to each "assigned to" with the row that generated into the Form. Anybody know how do it?
-
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…