Formulas
Discussion List
- this is my formula: =IFERROR(DATE(YEAR([Effective Date]@row) + ROUNDDOWN((MONTH([Effective Date]@row) + ([Contract Term (Months)]@row)) / 12, 0) + IF(IF(MOD(MONTH([Effective Date]@row) + ([Contract Te…
- I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of e…
- Hi, I have created a form for our clinical therapists to enter type of service or referral provided for particular clients each week. I want an automation that takes this data and lists services provi…
- We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without t…
- Good Morning All, I am having with an issue matchhing data between two sheets based on certain criteria. 1st sheet is a list of form responses. I have a name of requestor column. I need to complete tw…
- Hi, Here is a background on what my ask is: We track publications on Smartsheets and the publication activity column has the following drop-down options: Journal Article Meeting/ Conference Abstract/ …
- Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal ali…
- Hi everyone. I am hoping you can help me. I am trying to average the time it takes individual case managers to complete a case between specific dates. The reference cells are {CM Text} in the main she…
- How do you convert the first row to mirror the header row? The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we typ…
- I want to create a formula with a fixed date at the top of the sheet. There are subtasks with actions that must be completed a specific number of days before this event. Each row of tasks corresponds …
