-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Control Center
Hi, does anyone use SmartSheet Control Center solution? I have not been able to find anything on it outside of SmartSheet marketing. Thanks
-
Task not scheduling properly
I have a plan in a smartsheet which isn't scheduling as expected. several task that have no predecessor seem to be staying put. I'd expect them to move to the project start date. I can find no option to change constraint type. I've exported it to MS Project and it exhibits the same behaviour until I review the Resource…
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
-
Help on formula: Monthly savings calculation
Hi, Please need your help on how I can calculate my monthly savings on completed projects. I am currently using the below formula but couldn't get it right. =SUMIFS([Negotiated/Potential Savings]:[Negotiated/Potential Savings], [Actual End Date]:[Actual End Date], <=[Summary Info 3]41, Status:Status, "completed") Kind…
-
Help on Formula: if function
Hi all, Please need your help. I'm new to formulas and I've been trying to figure out the right formula for my project status and progress report but I kept getting errors. I have tried the below formula in excel and it worked but not in smartsheet (the smartsheet formula below is another trial I did that did not work).…
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Add a New Task with all the sub rows
I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
