-
If(And Future date formula not working..please help
I cant see it for looking, this formula should work (attached0
-
Wanting to count dates within a column
Hello, I'm trying to create a monthly report from quarterly data. I want a formula that will count how many projects went live in a given month from a column of dates. In the screen shot, I want to put a formula in the blue cell that tallies the Actual Live Date column. Thoughts? Thanks! Shannon
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
Export to MS Project
Hi, When I export a sheet with a Gantt chart to MS Project, I loose all the data on task duration, dates, predecessors, etc. Is there a way to export keeping this project information intact? Thanks, David
-
Editing Alerts & Notifications - how do I get rules to fire on existing entries
Hi All, Basically I want to know how I can re-fire alerts and notifications that failed due to errors and have been subsequently edited. Example described below We are testing a new smartsheet using alerts and notifications and a multi step approval process based on thresholds. We submitted multiple Smartsheet forms today…
-
Smart Sheet I have a question......"Save As New"
Hi Team, If "Save as New... gives you "Date & Formatting Options" to tick and untick what you want. Sheet data & Formatting, Cell linking, Sheet filters and forms, attachments etc. etc. Why cant there be an option to have "formulas" move with the row to another sheet. If you "Save as New" five times, then you have five…
-
Notification in Template
I created a notification and saved the sheet as a template. When using the template to create a new sheet, it retains the notification but not the email address in the notification. I set the original sheet to use any email address but apparently that setting doesn't transfer to the new sheet. Then I shared the workspace…
-
Formula Working in Most Rows, but Incomplete in Others
We have a sheet that automatically generates a job number based on how someone fills out a web form: =IF([CLIENT - REGION]1 = "HMA - Hyundai Motor America", "HMA", IF([CLIENT - REGION]1 = "HDAA - Hyundai Dealer Association", "HDA", IF([CLIENT - REGION]1 = "ADI - Adidas", "ADI", IF([CLIENT - REGION]1 = "MOGUL - Federal…
-
Sheet Speed problem
I have a sheet we are using to track payments etc with the layout is simple First Col is the Colored dots Red/Yellow/Green Cols 2 to 7 are just plain data 3 are date fields the rest are text Col 8 has the only formula = TODAY() - [Check Date]1 However the issue is the speed of the sheet, it acts very sluggish and the first…
-
Mobile App Update Requests
Is it possible to track update requests in the mobile app? I know we can send update requests from the app. But, I don't believe we can view update requests that have already been sent. Please prove me wrong! Thanks, Dustin