-
Birthdate Reminder or alert
HI Everyone I am battling to set up a birthday reminder I have my DOB date column and in a another column am trying to convert the birthdate to a current year date so I can use it for Birthday reminders but I am really battling Have tried coping a number of examples but they just dont work
-
Customer worried about Sheet copying
Hi I have a customer that is worried about loosing their 'secret sauce'. That is, having their process logic stollen. The scenario is that a rouge user, say editor no sharing, performs a Save As. They then do a quick account upgrade and then 'Save As' this copy sheet, which they now own, off to their own workspace…
-
I want to make a formula to work for all rows, details are below, Thanks!
This smartsheet has a parsing formula that we cannot convert as a formula column, I want this formula to be converted in a formula column, please guide, Thanks!
-
How to automatically add a "Date+2 days" formula to a cell when a new row is added?
In our request tracking database, currently if a Date Requested is "in the past" and another condition is not met, the entire row turns red to alert us of a new request. This is great, except that sometimes the request comes in after hours, and first thing the next morning the row is red. This gives our clients the…
-
Need a formula to recalculate a deliverable at the end of each week
My project is that a certain number of Forms needs to be created within the next 11 weeks. We have a group of people working on the project and right now I have the weekly goal for form creation divided by the weeks left. I want the formula to recalculate the weekly goal for the subsequent week at the end of each current…
-
Combining IF and COUNTM?
Hello, all! I need to count items in a multiple option column, but only within a certain date range. If this were a single selection, I would use COUNTIFS, but this is different. Do you have advice on how to do this? I appreciate any guidance you can offer!
-
Increment number if same date
Hello. I am using a formula to remove the slashes from a date. I would like to use the resulting value as the row's unique ID, by adding an auto incrementing 2-digit suffix. Here is the formula: =YEAR([Date]123) + "" + RIGHT(100 + (MONTH([Date]123)), 2) + "" + RIGHT(100 + (DAY([Date]123)), 2) + "-01" Which returns…
-
Auto number Task Name/primary column with indent
Hello, I am new to using Smartsheet for project planning. I am directly writing tasks into the Task Name column for a new, shared project. Thus, it is getting tedious to manually write "Task 1.1" for the child task of the parent Task 1 because the tasks can be edited/moved. Auto-numbering a new column did not seem to help.…
-
Nest IF formula
I have tried looking at the help but it doesn't provide details on creating nested IF formula. I am trying to say: If the column has name 1, then return statement A; if the column has name 2 then return statement B, if neither then return statement C. Any tips?
-
Nested Formula using BLANK and MONTH lookup
I want my query to look up the Finish column to determine what month it should display, 1 = January, 2 = February, etc... but if its blank, I want a blank to appear. Right now it says "Invalid Data Type". Can you help fix this query: =IF(Finish@row) = " ", " ", IF(MONTH(Finish@row) = 1, "January", IF(MONTH(Finish@row) = 2,…