-
Community Suggestion: Submit Product Enhancement Requests
Every once in a while, I get an idea and wonder why I did not think of it before. When you see a post on the Community that asks for a feature, enhancement, or bug fix you want, click on that "Submit Product Enhancement Request" link to the right. Capture the link for the post you are referencing and say "See this post"…
-
locking a task start date
howdie...how do I make sure a start date of a task doesn't move...but the end of the task does move if linked to/dependent on the end of a previous task that takes longer to finish? help please! :-)
-
COUNTIF with WIldcards
I have a survey sheet where all columns start with specifc chars: D-, I-, O-. Each contains differing descriptions following the "-". I want to create a sum of all "D-", "I-", etc. disregarding the descriptive text following the "-". I am using COUNTIF([Column1]:[Column X],="D-*") with no luck. Always returns "0" unless I…
-
Formula to include a specific range and all new entries
Hi, I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries. Can you please help me? =SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)
-
Granting full Admin Permissions
I have taken on a new role in my organization and will be managing much of our content and data on our Smartsheets--which has already been in place and established with content prior to my arrival. I am finding myself very limited to what I can edit and share with already existing sheets (even though I have been made…
-
CountIF a cell word starts with
I wanted to countif number on below example. it should bring the count 3. Example : Cell-2 - "Fail - Item not available'" Cell-2 - "Fail - item out of stoke" Cell-3 - "Fail - routed to wrong one"
-
Progressive Reminder Date Reminder until task is updated
I have a reminder set to notify a person 7 days before a calibration date. Is there any way to have the reminder sent every day until the calibration date is updated with a new one?
-
Template on Real estate Repairs Management
Hi, I am Trying to get a template if someone already worked on Real estate Management I am in charge of managing 1 of my Real estate clients Repairs & Maintenance We get calls in Or Via Email of issues i have to see when our crew can go over and then assign it to the right Field Crew Now i was thinking of doing 1 master…
-
Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…