-
Personal consultant
Hello Everybody, I need assistance for building a solution for my company with smartsheet, I'd like to know if I can have support by a freelance expert or a partner. I'm in Italy, so it would be great if we could speak italian, but in english is also good. You can write me at f.cesaroni@immoveo.it Tank you very much
-
Newbie Question: Want to Count "Product Name" but only if its date is in the future
Hello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting to highlight it if there is more than one time the product is mentioned.…
-
How do I create a Index/Match formula w/ a condition across sheets?
I have a sheet with a bunch of site location data. This sheet includes a check box column showing if the site is Open (Checked = Open). I have another Project sheet where I want to pull in only the OPEN Sites and populate 3 columns from the Location data (Site Name, Region, & Size). I am having a hard time finding a…
-
Back up not complete
I requested a back up of my smart sheet on the 24th. It is still pending. Who do I contact to get that back up. Smart sheets won't let me attempt another back up with that one still pending.
-
Filter Including Parent Row(s)
I have created a filter for one of my sheets but would like to include the parent rows for the rows matching the filter criteria. The filter is for all rows with "February" as the invoice month - see the screenshot below for more detail.
-
Switch Formula
Hello, I have recently integrated a project plan from MS plan to Smartsheet's however I can't seem to get the auto RAG Switch function working working as it was in Project Plan. This is the formula I used. Can anyone please help :) Switch( ([% Complete] = 100), "C", ([Baseline Finish] < Now()), "R", ([Finish] > [Baseline…
-
Formula for RYG Symbols in Child Rows to Update Parent Row
Hello, I'm wondering if there's a formula that could automatically update the parent row in a column that has RYG symbols? The parameters would be: -Green overall (in the parent row) if all children rows have green symbols? -Yellow overall (in the parent row) if any children rows have at least 1 yellow symbol? -Red overall…
-
Lock all rows in a sheet
Morning, I need to be able to stop anyone other than the admins of the sheet from adding rows but I also need to give users "commenter" status because I want them to be able to use the comments. How can I make sure the only ones allowed to add rows are admins? Thanks
-
Setting Formula using RYG
Hi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=Somewhat, Green=Yes. I am not even sure if this is possible. Any input advice how to…
-
ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3weeks from the due date will show in that column and so on I appreciate your help Rob
