-
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…
-
Can I use a form to complete a partially-completed row?
I know forms are used to add data to a sheet, but can a form be used to complete/edit a row that is already filled in?
-
My formula works fine with no errors, but no value appears. What is the issue?
I am using another sheet for the lookup_table. The other sheets basically has the currencies and the rates of each currency. What I want to do in the sheet where the function is; basically once a row is added and the currency has been selected, I want it to generate the value of the currency from the other sheet.…
-
Need a way to identify if a row has been approved/rejected via proofing
Hi, I am using the new feature "Proofing" for my upcoming project and I was wondering is there any way to identify if a document on a row is approved/rejected, then use it in the custom formula to change the status of the row? For example if a document is rejected then I would like to change the status of the row to…
-
How can my rows autofill the formulas when a new entry is generated through a form?
I have worked out several formulas in my sheet. Now I want them to be autofilled whenever a new entry is filled through a form. I don't want to drag them manually everytime there is an entry because I want automated workflow to follow. Also, if I drag a couple of cells prior to the forms being filled, then what happens is…
