-
ISBOOLEAN help please
Hi Team, I have a formula that calculates tax automatically as I enter the amount. I wanted to add Checkbox column, when I tick the box it removes tax and if its untick it continues with original formula. =IF(Status1 = "WON", [Value of Jobs Including GST]1 - DepPaid1, ""),ISBOOLEAN, [Value of Jobs Including GST]1-[GST]1
-
Project Plan views / Task assignee see's just their tasks
I have read posts where it says to use project plan FILTERS or create one off REPORTS to execute this requirement. This seems inefficient and each option lacks what the other provides. NEED: I want an all in one feature within a project plan where I can set 'resources' view permissions based on when they're assigned a task…
-
How can I select data that is older than 365 day?
How can I select data that is older than 365 day? =COUNTIFS(Product:Product, "ABC", [Project Complete Date]:[Project Complete Date], "Where Project Complete Date is < 365 days from today"
-
Change RYG Automatically based on values
Hello – I am trying to create a formula that will change RYG automatically with the following criteria: Green: Any positive (%) Yellow: 0 to negative 10% Red: less than negative 10% With the below formula, green and yellow work fine but not red. How close am I? =IF([% OVER (-) UNDER (+)]5 > 0, "Green", IF([% OVER (-) UNDER…
-
Row Attachment: Link (URL)
I use Smartsheet to track video production in my department and there is a request to associate video links (vimeo urls) to each project row. I've tried creating a whole new column containing a hyperlink, but that clutters up the master sheet and its information is not benefitial to sorting or report generating. The other…
-
Forms
Is there a way to make templates for Forms and then add them to each of our projects? I see where you can build forms and then clone them inside of a sheet but we would be looking to copy those forms into other sheets. Is there an easy way of doing that? Thanks!
-
Time Tracking - Formula needed to total time spent
Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant seem to get the formula needed to add the columns for Start time & Stop Time to calculate and provide a Duration for actual…
-
for two criteria query should I use LOOKUP or INDEX MATCH
I need to populate the low range based on a match to a specific specialty and tier. The specialty is just a drop down but the Tier was based on the following IF formula: =IF([Points Total]11 <= 15, 3, IF([Points Total]11 >= 16, 2, IF([Points Total]11 <= 45, 2, IF([Points Total]11 >= 46, 1)))) * Question 1: Should "…
-
Hyperion Link
Hello - Is there a way to link Hyperion directly into SmartSheet? New user and trying to determine the capabilities. Thanks!
-
Published card view not showing filters?
I'm using card view as an internal support ticket queue that the company can view. There are teams within the company and I want them to be able to quickly view their specific tickets without the other team tickets showing. Filters seem like the best solutions (there are other solutions but not as pretty) but when I…
