-
Creating a Calculator
Hi All - I'm trying to create a calculator in SmartSheets. I'm envisioning it as a pseudo GUI that leverages data from different sheets that we've populated, whereby we input values into this calculator, and it calculates based on predefined equations. There's ways to get close to it through a form or directly in a sheet,…
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…
-
How to calculate Status Indicator using %Complete and Target Finish Date
I am trying to achieve the following: IF the %Complete equals 0%, then status indicator is Gray. IF the %Complete equals 100%, OR the %Complete is less than 100% and Today is before the Target Finish Date, then the status indicator equals Green. IF the %Complete is less than 100% and Today is within 1 week of the Target…
-
How can i read activity log using c#.net through API...?
I need to restore a specific row which are deleted from the original sheet, and i am using API to achieve this with C#.NET. Our idea is to create new helper sheet using c#, which contains deleted rows in it, That has to get updated by reading data from activity log May i get any suggestions. Thank you in advance.
-
Today Function
I'm using the Today function to track weekly data counts. I'm wondering if there is a way to use the function to work backward from "Today" instead of forward?
-
Milestones showing at start of next day vs. end of day
I noticed a change in the milestone logic today, and I'm wondering if there's a way to revert back to how it was before or if there is something I'm missing. Before today, a milestone (a task with 0 duration) would show that milestone occurs at the END of the day of the predecessor task. But now, it has the milestone task…
-
Project-based timesheet approval + automatically add team members to a project
Issue: For a Project-based timesheet approval flow it is necessary to add the team members to a project. A Project Owner needs to add someone to the project first to be able to see their time submission. Booking someone for a project for the first time, would make this person a team member. However, RM isn't handling this…
-
Resource Management: Restrict Use of "Non-Phase Specific" Phase
The Projects I run tend to have phase budgets that are beneficial to be tracked for Post Implementation Review. My Team Members are able to record time on the top level of the Project - this is not helpful for reviewing the specific components. I would want to restrict the ability to record time on non-phase…
-
Merged: Predecessor Complete Column or Formula
This discussion has been merged.
-
How can I best organize lots of different 'tags' to sort through
I'm moving a sheet over from Google Sheets. Right now we have a column for 'Specialties' for different medical providers and it contains keywords we need to be able to search by. I need to be able to sort through this data quickly. I don't necessarily want it as a drop down because there are over 100 different…
