-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Export smart sheet
Hi, I wish to export existing sheet data by last year month wise, i. e. i am using smart sheet since 2017 to till date, i am using smart sheet to maintain data and with getting updated by team, i wish to be have a data month wise which i haven't saved it on my PC and now i wish to see month wise data. please guide me how i…
-
Entering data in grid view
Is there a way to have a blank row at the top of the grid view (automatically) when entering a new line instead of going to the bottom to add a new line? I know you can insert above, but can it be set to automatically be there?
-
Bank Statement Checklist and weekly notification of missing statements
Good morning, I am trying to build/find a Bank Statement Checklist that will notifiy me of all missing bank statements. For example, as of today, we should theoretically all bank statements from October 2018 and prior. I would like a monthly email sent out notifying me or somebody of all missing bank statements. I am…
-
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
-
Screen blurs for lengthy formulas, or multiple parentheses
Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ? Example : =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…
-
Just some thoughts on Shaine and Corinne
So, I put some words down about two things: Shaine's pending departure and Corinne's pending arrival. Neither of you are mentioned by name here: http://ronin-global.com/2018/09/15/passing-the-torch/ but ... it is about you. Shaine, thanks for all you have done and Corinne, I look forward to seeing you in your new role.…
-
Critical Path Not Showing up
Hello, The critical path for my project is not displaying properly. It only highlights a few tasks while it should be highlighting many more. I have predecessors and duration enabled, and I have looked through the forums to try to fix the problem. One possible answer may be that the timeline has paths in parallel. Is there…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…
-
Can Viewers hide or filter columns that don't pertain to them?
My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only). For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.…