-
Multiple IF AND ISBLANK Criteria in Formula
What I'm trying to accomplish: If [Approved] is checked, change [Status] to "Complete" If [Ad RSS Link], [Subject Line], and [Done] are not blank, change [Status] to "Proofing" If [Ads Entered] is checked, change [Status] to "Proofing" If none of the above are true, [Status] will be "Waiting for Information" Here is the…
-
Apostrophe being inserted before Formula when using Smartsheet Forms
Hello, we have a Sheet setup with a Column which has the Formula =[Project]@row + " " + [Note]@row taking the info from the Project and Note columns. We also have a form for this sheet where you pick the Project and add a Note, what happens when we complete the form is a Leading Apostrophe is inserted in front of the…
-
CONTRACT EXPIRATION DATE
1-I am trying to reference another to provide results of contract expiration date - 2- I would like to display in a dashboard the percent of total contracts that has expidered, will expire in 1year, 6month, 90 days 30 days, 14 days and 7 days 3- finally if there was an extension, to input that date in a new column that…
-
Formula Question - Pulling in Multiple Criteria
I currently have a couple COUNTIFS formulas where I'm capturing the type by person by month as my criteria. I need to keep this criteria but add the condition that if multiple workers is selected in the source sheet (in a drop down with 3 options), to count the number in the correlating # of multiples column. The problem…
-
Formula in metrics sheet to average numbers in column in source sheet
I have a source sheet containing two date columns and a helper column containing a formula to calculate the network days between the date columns. (Example of several rows of my 600+ row source sheet.) In my metrics sheet, I want to calculate the average of the Days to Complete Termination column in my source sheet and I…
-
Formula for difference in time
We run events and are putting together the tech runsheet which has a column for: Time Start Time Finish Timer The timer column is what a speaker sees on their foldback monitor for how long they have left to present. I need this column to show the "difference" between Time Start and Time finish. (ie in the first row it will…
-
Multiple IF and IF (AND) arguments in one formula
Does anyone see any obvious issues with this string? I'm trying to pull from two columns [VA Feed status], [QA Feed status] and output one status based on the column statuses. This is a combination of IF(AND) and also just IF statements. I'm currently receiving #UNPARSEABLE =IF(AND([VO Feed status]@row = "VO: Pending file…
-
Indicating a row is past due
Hello everyone, I was wondering about a capability in Smartsheet. I was hoping to indicate a row was not completed on time. I am not talking about conditional formatting per say. I do not have a preference how this is shown but I was thinking of a function where a cell column of that row is in red? This Smartsheet is used…
-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Formula or conditional formatting for highlighting unique task names
Hello Smartsheet Community, I wanted to "copy" condition made in excel into my Smartsheet, and can't get it done right. I would need to highlight unique title for the task, which doesn't exist in a different raw. I tried some different condition option but it only highlight either blank rows or every one. No idea if this…
