-
Stringing Logical Arguments
Hello, I have been struggling with this formula for a few days now and can only get bits and pieces of it to work. So I am hoping I can get some help here. Essentially I am trying to create a formula that includes 5 fields and depending on what is in them, give me three possible outcomes. The fields I have are: 1.…
-
Run Report on 'Highlighted Changes'
we have a large smartsheet with 300 (plus) rows and 25 columns and wish to quickly focus in on any cells that have had a change. I understand how to use the 'highlight cells' function, but the problem is that i then need to scroll down through all the data to see any highlighted changes. Is there a way of getting what we…
-
Joining two formulas, IF and NETWORKDAYS
Hi I have the following formula but only want it to be run where my task is in a 'Not Started' status. =NETWORKDAYS(Start1, Finish9) Is there a way to run an IF statement first as part of the above formula? I have tried running an IF statment in a hidden column but can't seem to link two together. Thanks Phil
-
calculate a running total from updated cells
I have a spreadsheet which tracks the order process . A simple dropdown list qualifies a cell as either "quoted" or " PO received". Once that cell has changed to "PO received" I'd like to deduct the qty for that order from "stock in warehouse" so That I can see at a glance how much available stock I have. Is there a…
-
Date as column type converts the date into US format but not accurately and hence makes the data ina
Column 60 is the accurate information Creation date has had the type specified as Date, it did not work with the dates in march until the 11th of March and likewise for the 1st of april. I am unable to understand the pattern either, can the Date format be used in dd//mm//yy format please
-
Gantt Chart view for Daily / weekly / monthly Scheduled works
Hi all, We are new to this amazing product. We have separate 9 sites that have numerous different types of scheduled maitenance required at different times. Is there a clear way of displaying this in a gantt chart or spreadsheet type of format? example - Daily clean, weekly service, monthly polish, yearly audit. Thanks in…
-
Notify Dependent Task Assignee That Predecessor Task Has Been Completed
Here's the setup: I'm trying to get team members to use Smartsheet more. One of the ways I'd like them to use it, is to get them to mark a task as complete once it's been completed instead of me chasing them around and asking them if they've completed the task and then checking it off for them. I'd also like to automate…
-
Disable Button for Sights - Enhancement
Can you please put in an enhancement request for me? I would like to have a disable button for the Sights (simiular to the disable button for conditional formatting). I have to basically rebuild one of my sights and would like to keep the people I have shared it with from seeing the sight all out of wack until I'm…
-
Check Multiple Boxes or Tag Multiple Items Within One Cell?
I know I've asked this in the past like 3 years ago but don't know if there mght have been a feature update or workaround for this yet. Is there a way to check multiple boxes or tag multiple items within a single cell? If I made a dropdown menu of 12 items for example, is there a way to check or select 2 of them for one…
-
Cross Sheet Resource Leveling
Here's my dilemma... 13 simultanious projects with a single team of 12 -14 people plus a few outide vendors and contractors. I can set dependancies within a single project and carefully arrange schedules to maximize effeciency and make sure no one is over allocated. OK, no problem. And yes, before Craig asks, I can even…