-
Data movement between sheets
Hello! I'm new to SS - is there a way to use conditional formatting to have data move between sheets. For example, when a cell has a specified value, the row is copied to a different sheet? Thanks in advance!
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Formula(s) for calculating past due items on a construction punch list.
I'm creating a simple punch list template and would like to add some date calculating functions to it but I'm very unfamiliar with creating date formulas. I'm attaching a screen shot of this rough template with a sample line already entered. I would like to create a formula that will tell me how many days past due items…
-
Count if formula and task progress
Hi, I've been trying every way possible to set this up so hoping someone can assist-- I would like to create a dashboard with a pie chart that shows how many tasks with a due date for the past 30 days from a sheet are done or incomplete. This seems simple enough, but Smartsheet keeps telling me I can only use numeric…
-
Hyperlink to external drive
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
isFormula function.
I would like a way to determine if a cell contains a literal value or a formula calculated value. For example: On a project sheet we have multiple date fields for different actions to complete on the same item. By default we use formulas to generate estimates for all the date columns. Some users may enter an actual date to…
-
Is there a list of hex code / color codes?
Is there a list already generated for the 40 colors available for selection? ie #FFF200 = Yellow Craig
-
My Cell is Red for NO Reason!
The title says it all. I have a cell, inside a column (obviously lol), and its red. I have no idea whatsoever why it is red. Is it mad at me? (lol okay, no more jokes I promise) I do have lots of conditional formatting in my sheet, and in this column too, but the other cells are behaving as expected. I tried satisfying the…
-
Drop Down List
Does any one know how to add a date and comments in the same field. For example - "08/15/2018 Left Message". I want the date of the activity to be documented in 1 field.