-
Reverse Engineering a Timeline
Is there an easy way to reverse a timeline that was originally based off of a start date, but should be based on the end date? We plan a lot of meetings where the meeting dates are always moving and we want to adjust the way we have our timelines so we can change the meeting date and Smartsheet can fill in the dates of the…
-
Autofill compliance
User Mgmt: I have users entering data into a sheet. They are not always inserting lines in a manner consistient with Autofill and some formulas in hidden columns are not filling in, "breaking" the sheet. Does anyone have any strategies for making sure people follow rules that allow autofill to complete? I have trained ad…
-
Sum using symbols
Can I sum the columns where I used a symbol to show the value? for example - if I use the Stars Symbol for 'Size of effort' - Empty stars = 0, 1 Star = 1... and the Faces for 'level of urgency' - No Pain = 0; to Extreme Pain = 5 the total Size + Urgency should be ~ 1 star + Extreme pain = 6 If I use the basic sum formula…
-
Date Formula dependent on text
Hi All, I am looking for a formula that can ideftify text in a column and convert it to dates. More specifically I need it to pick up a cell says "X" convert to today's date +30 days, or if it says "Y" convert to today's date +30? I have found a formula that works in identifying only one set of text: =IF([Project Name]34 =…
-
How to count only Green symbols in status column
I am trying to count only the green ball symbols in my status column. I have looked around for a formula to do this and so far have some across COUNTIF(CHILDNREN) formuals. I don't have my sheet organized with children so I don't think that will work for me. I am looking for the return vaule to be a number. I have tried…
-
Count Risks only when checkbox is open
I'm trying to create a formula that only counts the risks (High, Medium, Low) when the completed checkbox is not checked off. I have a formula for counting the number of risks (=COUNTIF(Risk:Risk, "High") + COUNTIF(Risk:Risk, "Medium") + COUNTIF(Risk:Risk, "Low")) but I have another column for "completed" that I want to…
-
Scheduled Monthly report of previous month's activity
to all my formula gurus, Need some help thinking this through. I want to schedule a report that runs on the first of the month and pulls all data from a sheet where a "Closed Date" occured within the previous month. So on Feb 1, the report would pull all activity in the month of January where the "Date Closed" occurred…
-
What determines the country (currency) of a sheet
Prior to the latest release currency columns displayed as $0,000.00. Now it displays as CA$0,000.00 which adds clutter. All our computers have US as regional Settings. If I change my personal seettings to Canada the CA goes away but the date format is d-m-y and can't be changed to m-d-y, so changing the settings is not an…
-
What formula should I use to count R,Y,G symbols in a column?
Hey folks, I want to count the number of red, yellow, and green symbols in a column. Does anyone know the formula to achieve that result? Thanks, Kenny
-
Track date change for column
Hi--I know I can track when any change is made to a specific row. And I know I can right click and see change history for any given cell. But is there a way to bring that date into the sheet itself so that it can be used in formulas (for example to compare the date that a certain event occurred in relation to the date a…