-
% Concluído x % Planejado
Olá, como fazer para criar 2 colunas com calculo de % de conclusão? Eu precisava controlar nos cronogramas de projetos o "%" concluído x o "%" do que havia sido planejado, como tem no project. Alguém consegue me ajudar?
-
Report not filtering out all 100% complete tasks
I have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two years, with two different schedules. But now two items won't fall off of the report (the…
-
Send Weekly Request to Complete Survey
I am interested in sending each of my team members a weekly Temperature Check survey. I created a new sheet to collect their responses, and a form with the questions. I believe i have an automated workflow set up so that an alert is sent to each team member every week at 2:00 pm on Fridays. In the Message, I included a…
-
change entire background of card view?
Is there a way to change the background of the overall board in card view? Not the cards themselves, but the default gray background, can we change that? I haven't found it if we can.
-
Using If AND FIND formulas together
I am trying to use if and find formula to look some letters in strings at the different cells. And if they match with each other I want to give output as "TRUE" and they don't I want to say "False". For example I am looking $ sign in different rows and if they match I want to have output as "TRUE" and If they don't…
-
Formula for difference in timestamps
It is my understanding there still is not a formula to calculate time. Any word on when smartsheet will be getting that functionality? Is there anyone who may be able to help me with a work around? We are using a form to dispatch jobs. When the form is submitted it auto populates a row that will be timestamped. When the…
-
New Formulas
It seems there was recently an update that included a large number of new formulas. Does anyone have the comprehensive list? Any special notes about individual ones?
-
Creating % complete for each parent row?
Hello! I'd like to show the % complete of each of these training modules on the associated parent rows. I've attached a screenshot. Happy to add/remove columns, etc... Can someone please assist?
-
Trial emails
Hello, I'm a licensed user to Smartsheet and if I share my sheets with other users in the organisation, they have to sign up to view them. That's fine, except they're then bombarded with trial emails (You have a 30 day trial, upgrade now! etc.). I don't want them to be a licensed user, I just want them to collaborate on my…
-
Importing excel IF/And statments to Smartsheets
I use the below IF/AND statement in excel. It works fine. =IF(O4="Close","",IF(D4="","",IF(AND(M4>0,M4<=0.1),"YELLOW",IF(AND(M4<=0,M4>-0.1),"GREEN",IF(M4<-0.1,"PURPLE",IF(M4>0.1,"RED",)))))) When I import it into Smartsheets, the formula is below and doesn't work. I get #UNPARSEABLE in the cell. Does anybody know why the…
