-
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-…
-
IF/OR Formula help
Trying to Auto-fill a value in one column based upon "fixed" drop down list of values from another column. So this is the formula I am starting with. =IF([Product Family]1 = "7765", "252 Industrial", "265 Commercial") I have (3) additional values I want to include that will satisfy the true portion of the formula. How do…
-
Check boxes and formulas
Hello We are using Smartsheets to build ships.. but I have an issue with the formula(S) I want to be able to use a tick box for a formula.. We have many options priced and I want to use the tick box to generate option pricing. If the box is ticked then the price will move to the next column that is auto summed. If its not…
-
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
-
Report with resource allocation rollup
Hi, I am looking for a solution where I can roll up resources by their allocation at a portfolio level. The resource view only shows me the rollup for licensed users. However, we have users that are allocated to projects that are not necessarily licensed to create or edit sheets. They are ok with read only access. I…
-
Red man
Hi, I am looking for a way to aviod the red man when a task has been completed. In my opinion the red man should disappear as soon as the task has been solved. Thanks for your input. Best Rgds, Birgit
-
Block non-working days for resources?
Hello! I'm trying to schedule around vacation dates and other non-working days per resource, not for the whole team or whole sheet. How can I block off non-working days for a particular person without doing it 'manually' and messing up the dependencies? Thanks for any guidance!
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…