-
Need a formula to count how many of each Support Type is assigned to each Assignee.
For example, for the DFM/DDFM Support Type, I would like to know that there are: Communication: (1) Ashley Pierce (1) Tanner May Proposal Review: (1) Alexa Briggs (2) Ashley Pierce
-
Can't embed powerpoint into Smartsheets dashboard
Hi all, I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached). Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/paste the iframes code. I have also tried Share with People and copy/pasting that link into the URL…
-
Is there an alternative for WORKDAY.INTL in Smartsheets?
Hi, I have a formula on excel that uses WORKDAY.INTL and it doesn't work in Smartsheets. I have made the formula so it only produces dates that are on a Tuesday, Wednesday and a Thursday. Is there another way to do this? Thanks, Liam
-
Need help with an "IF", "CONTAINS" and "OR" formula
Hello everyone First, thanks for your help :) I'm trying to make a formula. I have a cell (cell#1) that has 4 values in it (" one", "two", "three", "four"). I'm looking for a formula that would work like this: If cell #1 contains "one" or "two", then cell #1 =0. Otherwise, calculate the number of values in cell #1. Could…
-
Display Logo at the sheet level
Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to do is to personalise at the sheet level because within the same workspace I have sheets that…
-
Is it possible to count if a cell changes?
Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An example question would be: how many times did a cells in "current stage" column change from "Art…
-
Smartsheet Forms - hiding headings
Hi, I have created a Smartsheet form and require participants to ticket a box before questions start appearing. I would like to also apply this rule to the different section headings I have, as at the moment the section headings appear when the user opens the link, but the questions don't, therefore making the form look…
-
How you do get an automation to send an "Alert Someone" email.
-
Count(Distinct()) function that works with one column (range), but not another.
Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 columns is the data. Same column type, similar numbers, etc. Anyone had this issue before?
-
Can a user request an Update Request?
I'm using a form to collect shift information from employees (onto a master tracker). This shift information is filtered to 10 different reports, depending on the building and department. I need the user/employee to be able to modify their requested shift after they have submitted. The Update Request feature works but I…
