Formulas
Discussion List
- I want to know all the employees those have salaries 13 using Index formula. Presently I am using the below formula, which provides only the first Employee getting 13 salary (in the cell belonging to …
- Hello, I am trying to count the number of boxes that are checked in the "Missed Information" column and showcase the total in the bottom right corner of the Sheet. I have tried many different formulas…
- Smartsheets seems to be defaulting to adding/subtracting business days, but I want the formula to use calendar days instead, how do I do this? My current formula is =[Planned End Date]1 - 195. But I w…
- Hello, I have a sheet that tracks sprint numbers based on their date ranges. How can I identify the sprint number for a task using the task start date? Right now I'm using this very long formula in th…
- I have a sheet that contains costs for various projects spread out across multiple quarters for 2 years. I'm trying to find a formula that will calculate [Billed to Date] in each row based on the curr…
- About 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to co…
- Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love …
- for example: Tinley Park North (IL) FSU (Tinley Park, IL). Input: Tinley Park North (IL) FSU (Tinley Park, IL) Desired Output: Tinley Park North (IL) FSU I need a formula that can return the desired o…
- Hello, I have built the following formula but for some reason the last part of the formula is pulling a blank result, can anyone see what I have done wrong please? If the result is 12 and Internal it …
- Hello Smartheads! I have a pretty interesting use-case. Columns look like in the screeen below: E Entry Number - values can duplicate Desired outcome: Trigger: Auditor selects her/his user ID in colum…