-
How to indicate the Top5 from a smartsheet with Case-insensitive criteria?
Hello! This is my second question here. The community was incredibly helpful for the first one! :) - I want to pull the Top 5 Customers with more active projects from a project tracker (the user inputs project ID and from a data pool, the Customer Name and other info are pulled) to a dashboard chart. So far, I am using a…
-
Why can't I have a formula in %% complete when dependencies are enabled?
I just spent a very long time figuring out how to make the %% complete column auto populate based on the dates. I was proud of my work until I had to 'enable dependencies' so that I could have predecessors. Surely it cannot be that uncommon for people to need both. My investors get reports where the 100% complete column is…
-
HELP: Formula for Dashboard
Hello, I've currently built a form that allows people to Check-In and Check-Out, which then they'll have a drop-down and select their name. I've also built an automated dashboard which will indicate how many people are currently checked IN in each area. Some of our staff forget to Check-Out when leaving work. How can I…
-
Sheets Created from Pivots
Is there a way to tell if a sheet was created from a Pivot? Are there any properties within the sheet that would indicate how it was created? I am finding that with the transfer of ownership of Workspaces and Pivots, things aren't populating correctly. And is there any way within the Pivot app to see the destination sheets…
-
Formula Challenge Sheet
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 reference! However, since I moved job, I dont have a copy of that anymore neither I know where to find them! Does anyone has…
-
Adding days to a Date to determine a future date
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 Charge]@row + [Frequency in Days]@row Here is the result: The system is just populating the date in the Estimated Date of…
-
CountIFS - last month, current month and NOT cancel
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 current month.
-
Dashboard/ Report "Current User" Not Updating
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 filter based on "Current User", which is reading the Project Manager Column (set to Contact List). The issue I'm seeing is if…
-
Heavy Form entry traffic + Complex column formulas = Inability to SAVE manual sheet changes
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 created. (TL;DR summary and the real Discussion Topic at the bottom!) Last week, I put together a small Smartsheet solution…
-
Return value if a cell in the same row has highest value in the column
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 stumped. Can anyone provide this formula? VLOOKUP seems like the obvious choice, but I don't know how to reference a MAX…
