Hello! I remember I used to own a sheet called Smartsheet Formula Challenge (there are race cars visual in the sheet) that has few good scenarios/challenges on Formulas which I have been using as a re…
I am trying to create a formula that will look at the date within the row, look at the frequency and then determine what the next date will be. I am using the following formula: =[Estimated Date of Ch…
What am I doing wrong? This is my metrics sheet and I want to count if - last month has a date in the completed column and does NOT has a cancel status. I will need one for each last month and the cur…
Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filt…
Story time. This is a long one, so buckle up! This post is for anyone who might be having issues with saving changes on sheets with complex formulas while many form entries or new rows are being creat…
I'm working on an email campaign and want to see which issue has the highest open rate. If a value in Column C has the highest value in the column, return the value of Column A in the same row. I'm st…
To further explain in reference to this community post. here, https://community.smartsheet.com/discussion/57396/generate-list-of-unique-values-index-distinct-vlookup/p1 I've successfully been able to …
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches…
I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did t…
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests.…