-
Need a How-To: IF [blank addends], blank, IF [values], sum
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
-
Formulas not working in some rows
Hi there, I have this formula running in a field called Contract. This sums up all the pricing across this line. =SUM([Facility Rental]373 + [Curtain Fee]373 + [Chair Fee]373 + [Stage Fee]373 + [Porch Fee]373 + [Lot Fee]373 + [Rehearsal Fee]373 + [Cleaning Fee]373). This is working in some of the rows but not in all of…
-
Adding multiple users to Group
Hi, It would be helpful to be able to add multiple users to a new group using a comma delimited email list (or other) (copy/paste) method rather than having to select 51 different people separately to add to a group. Thank you.
-
Shared reports are blank
Hello, After performing a search I ran across many others users running into shared reports showing up as blank pages. I tried the solution I ran across and assured that the user also had access to the sheet the report was made from. And still I am seeing a blank report. Was this ever corrected in early/mid 2016? I am…
-
How do I switch my google drive account?
Hi, I've switched gmail addresses and have also switched the gmail address which is primary in my Smartsheet account. I log into Smartsheet with my new email address but when I go to attach a file from my drive it is getting the drive from my old gmail account. How do I update this? I don't see a way to do it from the…
-
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…
-
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…
-
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…
-
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
-
Please Help =IF(SUMIFS (Returning #Incorrect Argument Set)
IF(SUMIFS(Status2, "WON", [Probability Hit Rate]2, "1", [Value Of Jobs]2))