-
Error Message on Sub Tasks
Hi I created a bunch of sub-tasks and when I tag people in the comments and they get the email, when they click on "open in smartsheets", they get this error: "This card is not visible in card view because it is empty" Any idea what is causing this? Thanks!
-
Question: Can you identify the worksheet behind a form?
The subject really says it all. I know I can go into a worksheet and identify the forms created for it, but can I do the reverse or do I simply have to check every worksheet until I find it?
-
Auto-push sheets or reports To updates
I have two reports being sent each month with different "To" contacts. I want to add a new person to the list, yet cannot see a way to do this without creating a new automated report. Is there an easy way to manage the people receiving the report?
-
Subtracting dates
I have an excel sheet that subtracts dates. The formula is as follows: =IF(P4="","",NETWORKDAYS(P4,Q4)-SIGN(NETWORKDAYS(P4,Q4))) This formula works. When I use it in Smartsheets, the formula is as follows. =IF([POC Date (Planned)]3="","",NETWORKDAYS([POC Date (Planned)]3,[Actual/Pending Date]3-SIGN(NETWORKDAYS([POC Date…
-
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…
-
nested substitute
How can I use substitute to replace not only one but multiple letters? For eg: -0.-9 I want to get 09 only.
-
Search for Hyperlink
Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its not finding anything on my sheets. Any workaround for this? Perhaps there is a way to create a hidden column and a formula of…
-
Date problem
I recently ran into a problem with dates that were hard "mm/dd/yy" coded into a formula and populated in a date field. For read only purposes, this is fine, but it becomes a problem if you try to use the hard coded date for comparison with another date field, such as TODAY(). I did not realize that TODAY()'s date is…
-
Japanese text gets garbled when exported into PDF/PNG.
Hi please check the attached. I put some text in Japanese and tried to export the whole gantt into PDF/PNG. But what I see is the garbled texts for Japanese. I think this is a bug; can you fix this asap? Thanks, Koji
-
Formatting the Custom Message in an Alert
I would like to send an alert to each of my team members weekly at 2:00 pm on Thursdays. I created the form, and copied the URL. I created the Automated Workflow to send an alert to my team members, and include the URL in the Customized Message. When I tested this, the customized message, with three short paragraphs…
