Formulas
Discussion List
- There is a smartsheet template set in the solution center called New Employee Onboarding. In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for c…
- I am having difficulty with this formula that I would appreciate some assistance. I have a sheet with user names. If the user name matches that of a user name in another sheet, I need to select the ch…
- I need a formula that will return the date of Monday for the current week. So on Monday 08/05/2017 it will show 08/05/2017, but on Wednesday 10/05/2017 it will still show 08/05/2017. Please help!
- Hello, I have a spreadsheet with about 85 tasks and subtasks, the % Complete isn't working. It's show the percent completed as 99%, when only about 10 tasks have been completed for this project. I tri…
- We are working on a manpower tracking sheet and trying to create a link from one spreadsheet to another, which will lookup a resource and then find the latest date that resource has tied to it. This w…
- We are looking to establish a daily import of our project portfolio into SS via a CSV file. When I look at the task import schema, I cannot see a way for SS to identify the parent and child relationsh…
- What am I doing wrong? The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. A…
- Hello, I have a sheet where I am trying to reference multiple criteria from another sheet. For example I am looking for a count of Patient Fall with Injuries from a specific site. My formula is coming…
- Hi all, would anyone let me know of any 'string' limitations in smart sheets when creating a formula? I have attempted the below in every conceivable possible way and I can only think that the formula…
- Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called T…