-
Forms - SmartSheet Form not the same as Form received by Action Parties to enter data
I have a Smartsheet that tracks Action Items. I created a Form that shows Action Parties data from Smartsheet and requires them to enter responses. The Form sent to Action Parties that appears in Emails and can be opened from the Email to enter responses does not contain the same cells as the Form in SmartSheet. Why? See…
-
Ability to create a form that will reference rows instead of columns
I have an existing extensive sheet that is built upon rows, i can only seem to create forms based on column headers, is there a way to do this for rows?
-
Contact Lists and Formulas
Hello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-assigning a job. The formula works for inputing the right name, but only as text. Is…
-
COUNTIFS Formula "NOT" error
I want to calculate something for a dashboard. My formula references our team's tracker sheet. I am looking to use COUNTIFS for Tasks that are a specific Request Type, not a grand parent row, and not in our Archive section. The first part of my formula works, my Archive NOT rule is what gives me an error. I've included a…
-
Extract a value if today is between start and end date
Hi all, I've been trying to wrap my head around this and I have trouble trying to self serve to find an answer (or it's just user error on my end haha) I have a schedule with 3 main columns - the name, the start date and the end date. What I was hoping to do was extract who is currently scheduled if today was equal greater…
-
Can OR function be used with cross-sheet references?
I'm trying to use OR with SUMIFS in a cross-sheet calculation but it doesn't work. As an example the formula below yields a INVALID OPERATION error. =SUMIFS({TotalCost}, {Cost Center}, [Cost Center]@row, OR({Reason} = "Other", {Reason} = "Training"), {Region}, "Domestic", {Approved}, 1, {Year}, "2020") Thanks, TY
-
View All Formulas Used in a Particular Smartsheet
I would like to see a list of all the different formulas that are used--along with which cells are affected by these formulas--on a particular smartsheet. Is there somewhere I can view this?
-
Is there a way to format individual text/characters within a cell?
Are you able to format only certain text/characters with an individual cell, or does formatting apply to all the text/characters within a cell? If I cannot format only certain characters, this would be a great recommendation for an enhancement.
-
Notification on Formula or On Status
It appears that it is not possible to send a notification based on a formula if the sheet has not been opened/saved. Is there a work around within Smartsheet? Is it possible to send a notification every day on any rows that have a particular status (e.g., Open)? It seems there is no trigger (no row change/add). TIA
-
Change Status dropdown when task is assigned
Hello, Smart People I have a [Status] dropdown which includes Assigned, In Progress, In Review, and Complete. I would like to automatically change that status to Assigned as soon as the [Assigned To] column is not blank. I've found how to change status harvey balls or completion ramps, but not text-based dropdowns. Seems…
