-
Formatting for Project Lists - suggestion
I was hoping there was some formatting option so that when I set a status to complete (either green orb, full circle etc.) that there would be a way for that row to automatically be moved to the top of the sheet. That way the "in progress" and "completed" tasks/projects could be better organized. Just an idea. Thanks
-
Possible Easy Percent Question
Hi! I am trying to do a percentage of how many yes and how many nos I have in one column. I tried a couple of formulas and I am coming with some weird answers. For instance. =[Percentage of IPE Yes and No]1 - [Percentage of IPE Yes and No]2 / [Percentage of IPE Yes and No]1 and my answers comes out to be 4,773% I have also…
-
Task Report from Multiple Sheets
Hi Everyone, I'm wondering if anyone else has had the same issue with reports that I'm having. Relative SS newbie here so appreciate the help! We have a team with several contributors who are assigned work on multiple sheets across SS. I built a report to show tasks from all sheets that are assigned to each user. When I…
-
Row Sharing Based on Contact Column
I just got an account and would love to send one link to lets say 75 people and they would only see the rows that pertain to them. I would accomplish this by adding contact information for all and make sure to create a contact column type and grant access based on that column. Does anyone know if something like this is…
-
Two SUMIF Questions: NOT and Children
=SUMIF(CHILDREN(Status3), "Rejected", CHILDREN()) 1) How do you use the NOT logical expression in a SUMIF statement to add values together only in those rows whose value does NOT have a certain string? For example, add all of the cost values together unless the status says "Rejected". 2) For the condition test range of the…
-
Changing the Functionality of the Top Tabs
It would be great if there were options for the top tabs display. For instance, I have some sheets that have long names, but it would be really nice to have only the first word or two (or a character limit name) show on the top so that I could fit more tabs on the screen without having to use the pull down all the time.
-
Duration minus Actual Effort
We would like to be able to track actual vs estimated duration, as well as the variance. ie: Duration Column 4 days, actual work 2 days, variance -2. Duration Column 4 days, actual work 6 days, variance 2. And be able to roll the totals up at the top of each parent task. If a task is scheduled to take 90 minutes, but we…
-
Calculate each task's percentage completed by days gone by
Hi everyone, I have been trying to work out how to do this using lots of threads here but don't seem to be getting anywhere. I want to automate the percentage complete for each task, based on the dates. So if a task has gone past its end date, it would be 100% complete. Can anyone help? Many thanks, Katie
-
Filter - "at least one condition" - wrong results
Hi, I may be going mad, but I cannot get a filter with at least 1 of 2 conditions to work. Maybe my boolean is getting rusty... I have 2 columns with monetary values. I only want to show rows where at least one of these is bigger than zero. Nothing complicated. The settings are attached in the screenshot below. However I…
-
Smartsheet Budget Formulas
Hi, I would like to know the formula for the due date of every month to calculate the receivables and Payables. For example, I have the data with amounts and due date of the payment. How can I input the formula, grab the amounts by the due date of every month. Please let me know.
