-
Please Help =IF(SUMIFS (Returning #Incorrect Argument Set)
IF(SUMIFS(Status2, "WON", [Probability Hit Rate]2, "1", [Value Of Jobs]2))
-
Locking the top row when filtering.....
Hi Team, How do I keep the top row at the top when filtering (It holds all my calculations totals etc.) I understand we can’t lock it (if I’m correct), is there a symbol we can put in any of the top rows columns?
-
Filter Cards by Phase/Title of Parent
Is there a way in the Card View to filter and only see cards within a certain phase or cards that have the same 'Title of Parent'? I have a multi-phase project with hundreds of total lines and it would be great to be able to break up the cards to only focus on the current phase of the project. I'm also open to any other…
-
Update Request
We are using update requests, but when we select multiple lines, how does that person know which project is which. We have project numbers as our main column, but when I send an update request, with multiple projects, it doesn't show them which project is which. They can click through the three projects, but it doesn't…
-
Setting conditions for RYG balls
I would like to have the RYG balls automatically adjust based on another status column. For instance, if my outside sales people set the status of a row from bidding to the following: Status "Lost" = RED Status "Postponed" or "Unknown" = YELLOW Status "Won" or "Obtained" or "Negotiating" = GREEN Status "Bidding" =Will…
-
Exporting Attachments FROM Smartsheet to BOX
We are using Smartsheet to manage client data including a profile picture. Client info and attached photo is uploaded via webform to the Smartsheet. This photo needs to be edited and saved in Box so a) it can become the profile picture in their row, and b) can be available for printing an ID. I need a way to automatically…
-
Microsoft Flow - Inserting a new row on a sheet with Dependencies enabled
Hi, I'm currently trying this out to see if we might use it more widely in my organization. I'm trying to insert a row using Microsoft Flow, but I am receiving the following error: * End Dates on dependency-enabled sheets cannot be created/updated. Please update either the Duration or Start Date column. Based on another…
-
Lookups
i'm new to lookups in SS and am struggling to see where to put the data tables so that they don't interfere with the main body of the SS. I have 50 customers in a dropdown menu and i want to look up their corresponding; payment terms, account number etc See:…
-
Previous sheet opens!
Hi all, has anyone experienced the previous selected sheet opening when you click on a different sheet to open in the folder view? I've started updating the wrong sheet several times over the previous few days because of this... Any ideas? Regards - Roland
-
Published Report Links on iPad browser
Hello, I'm a new user and I'm trying to create a report that can be shared with someone who doesn't have access to the underlying sheet. I've created the report, published it, and copied the link into a Windows Firefox browser tab and it works perfectly. However, when I paste the same link into an iPad Chrome or Safari…
