-
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?
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
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