-
Enhancement Request: Allow Row Number retrievable from formula
I thought I had written an enhancement request for this before, but I have no record of it. I'd like to be able to retrieve the row number (not the ID, the number) using a formula. Some use cases: In this thread (https://community.smartsheet.com/discussion/finding-duplicates) Joel talks about having to sort prior to…
-
Predicting a bad situation
I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of days, C automatically is now going to be late by that same number of days. I'm looking…
-
Automated update request
Hi, I have a task that need to monitor status of monthly building reports to clients. The process is like as following: 1. Form department will generate building reports (each person in Form department has their own portfolio). 2. they will fill in the form on SmartSheet to input when they create the building reports and…
-
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…
