-
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
-
How to Construct a Formula: If Cell is Blank Return Value from Another Cell on Same Row
How is the formula written to do the following? If the cell called "Description" on row 1 is blank, use the contents of the cell called "Keywords" on row 1.
-
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…
