-
Countifs with OR across multiple columns
Hello all, I'm a fairly new (2 weeks) smartsheet user and I'm trying to write a formula that will count several columns based on specfic criteria. I want to count the number of Open projects (status) that are associated with engineering by either person/dept assigned column 1 or 2, and are of a safety concern (category)…
-
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'…
-
Film, Commercial or Television Project Management/Schedules template?
Is anyone using Smart sheet for there TV series, Commercials, Film projects? Looking for a template that covers Project development , Project Greenlight, pre production, shooting schedule, edit/post schedule... Looking for somethiing that will manage production scedule and producers/editors. Before I build it I thought I'd…
-
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…
-
Unlocking dates for smartsheet on ipad & smartphone
I am looking for advice on how to enable the dates to be edited on a smartsheet program when accessed on an ipad and smartphone. I can edit the dates of the program on a laptop, but when on site, I am unable to change the dates on an ipad or smartphone. Is there a setting I need to change to unlock this restriction?
-
auto resizing widgets in Smartsheet reports
Hi there, I'm creating dashboards and they are working well, but one annoyance is that there are many occasions when the data displayed in the report widget, is bigger (usually longer) than the widget frame. Is there a way to set the widget to auto size based upon the number of rows brought back? Many thanks, Matt
-
Connect Action log (dates) with a project sheet dates
Hello; I am currently working with two sheets, one is the project plan and the second one with an action log corresponding to one of the phases of the plan. I have an issue when I am trying to connect log date & due date of each of the actions of the action log, with the finish date of some of the activities from the…
-
the end date and the gant chart date is not matching
Any body has a problem similar to this: I set the end date at 2018, but the gantt chart showing a 2019 ?
-
Using Today formula in date field has limitations
Hi. I just wanted to find out if perhaps the =today() function does not work when using a sheet with begin and end dates and dependencies enabled. When I try to enter the function, it only shows the actual function statement and not today's date. However when I use this function on a sheet with only one due date column and…
-
If statements with multiple conditions
Hi, Hoping someone can help with a formula I am struggling to get to work for a specific scenario. I have a "phase column" in my project plan which looks at various parent rows for my project phases, i.e Discovery, Design, Build, Implement, Benefits realisation. The formula assesses the status of these phases, so I can…