-
Formula for capturing the date when the status column change
Hi, I have a completion date column. I want to know if there is a formula I can capture in the date column to indicate that specific date when the Status was changed to complete? Please help. Yovanka
-
Greater than less than
Im attempting to make something that AUTOMATICALLY creates a way to change a percentage... our table goes like so.. 45% and up is 8% on another line anything between 44-41% is now 6% and 39% to 35% is 4% anythign less than 34% is 0% .. This is my equasion I think im on the right track but it does not give me the right…
-
Report-level access to sheets
Hi, So, there are plenty of ways to view the data in a sheet, and to regulate access. My issue is when a sheet contains sensitive data, and that you want to give view and update access to only a few of the columns via a report. A good example is a column for internal comments and one for external/customer comments. Since…
-
Issue Calculationg Actual Durations
I have a project sheet where i added an actual start and actual finish. I also added an "actual duration" column, which is a calculated field. In that column is the following formula: =NETWORKDAYS([Actual Start]2, [Actual Finish]2) The problem is that in some cells it is showing a huge value. There isn't a rhyme or reason…
-
Conditional Formatting based on system columns (Attachments and Comments)
I can't find any discussions on this. I'm looking for conditional fomatting based on two of the three System columns: Attachments and Comments. These are not available today when trying to add conditional formating to a row. For attachments, I would like the criteria based on: - Changed: If the list of files has changed at…
-
Row Level Alerts
Hi, I would like to request a new functionality of adding row-level alerts. I know there is a discussion where Travis mentions workarounds, adding very formula-dependant sheet-level alerts to simulate row-level alerts. But this is a work around, and not a functionality. So this is an official request to add this new…
-
Nested IF's Based on Date and Additional Criteria
Hi All, I am trying to craft a formula that will help automate the pacing of tasks. I have four columns: Task Name (Text), Task Completed (Checkbox), Task Status (Green, Red, Yellow, Blue), and Task Due Date (Date). For Example. [Determine Target Audience] - [Checked] - [Green] - [1/24/2017] I am trying to automate "Task…
-
Formulas by today's date
I am able to figure out the fomula to count these items individual but i am running into trouble getting the correct format if i want to count # of clients that came in based on today's date at the specific location. Any help is greatly appreciated.
-
Filtered View in a Reminder
I want to use a filtered view in a reminder sent to all users of the sheet. Two other alternatives if that cannot be done would be to create a reminder in a report, or to stop the SmartSheet from displaying in the standard reminder. The goal is to send a reminder to team members that shows just the current phase of a…
-
Report Builder and Date sorting
I am trying to filter dates in report buider. I am using WHAT which gives me the option of manually inputting dates between . But when i use the run it doesnt filter to the date crieria I have used. I have tried to use the WHEN column but it I lose all the rows then and I cannot see the relevance of Modified or Created…