-
Help with writing a formula to show Completed and Past Due along with other status.
Hi there, I am able to get all the status to show correctly, except the 'Complete' and 'Past Due', I know its something simple and I am just not thinking of it, help is appreciated! I am using a 'End Date' and '% Complete' Formula used on the 3rd date down =IF(OR([% Complete]@row = 0, ISBLANK([% Complete]@row)), "Not…
-
How to display Name of the user who created record?
Created By displays email. How can I display the actual Name of the user who submitted record through form?
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
Formula for RAG rating based on status and dates
Hi Smartsheet community, I'm after a formula that will produce the different RAG ratings. I'm definining them based on whether they are on schedule and their statuses. Blue is 'Status'="Complete" Red is (open for advisory) 'Status'='Not started' and 'start date' < today and end date is within 14 days OR Status= not started…
-
formula that determines how many working days 2 tasks were in progress at the same time.
I have a Start and End Date for 2 tasks. (Task 1 and Task 2). [Task1 Start], [Task 1 End], [Task 2 Start], [Task 2 End]. I am trying to write a formula that determines how many working days both tasks were in progress at the same time. Any suggestions would be great appreciated. thanks
-
Help with a formula
Hi there, I'm looking for a formula that would look at an Identifier Column and pull back the Amount Financed. But if the Identifier Column is repeated, would only pull back the first instance of the Amount Financed. Here's a snippy of what I want that Quote Value column to look like. But I'd like to be able to use a…
-
Formula continuously updates cell even though values are not changing
Certain combinations of results are continually updating even though the value/result didn't change. Every time I open the sheet, it requires me to save but I didn't change anything. Combinations with issue: "Utility, Telecom, Waste" and "Utility, Telecom" Combination without issue: "Utility, Waste" Services column is…
-
Date Logic in Form
In forms it is not uncommon to have a Start and End date for any reason (mine is for PTO). It would be very helpful if there could be some logic added to Date fields to compare with other Date fields. In my case I need to add logic that prevents a user from entering an End Date that is prior to the Start Date. Today this…
-
How can I append additional text to strings pulled via formula from other cells?
I am using a large function to pull together a list of names based on whether someone has provided an update. The formula that I am am using is basically… =IF(Input from Cell X = "", [Contents from Cell X1], "") + ", " + IF(Input from Cell Y = "", [Contents from Cell Y1], "") + repeat. This works but it gives me lists with…
-
Date value is off of Modified Date is off by 1
Something has changed. I have a formula =[Modified Date]@row that captures the last modified date and keeps it static. I do this as I have rows backed up nightly to another sheet if they were modified. Just using Modified Date doesn't work as the date changes once it's on the new sheet. It's now rounding the date up. The…