-
Referring to a Previous Day
Can someone please assist in helping with a formula that will simply just refer to a value from a previous date? Example: Two Rows by two Columns. The top row has a date of 4/3/22 and in the Value Column it has 5. In the bottom row the date is 4/4/22 and in the Value Column it has a 3. If I wanted to add the two values…
-
Sheet Summary Report - Indent Function
HI , I used Smartsheet report tool to merge two sheets with common column names. Both sheets have their own indent function. I am able to create a indent on this report, but not able to save it. Every time the report refresh, the indent gets removed off. Not sure what's causing this issue. Can some one help me with this?
-
Forms/Workflow
I have an intake sheet that has several columns of information; when the project(s) are reviewed and set for approval to move forward with planning, I have a checkbox workflow trigger that 1) copies the data to another sheet (Project Agreement) containing less information (Project Name, Details, Scope, Out of Scope etc.).…
-
Creating Logic in a Form
I am new to the development of forms. My team currently has a form which collects weekly hours spent on assigned projects. Each member of the team opens the form selects their name and the specific project then provides the additional information requested. Is there a way using Logic that once the individual selects their…
-
Help! I deleted a shared item and I'm not able to undelete it. What can I do?
I accidentally deleted a shared sheet. I went to my Deleted folder, selected the item and chose undelete from the actions menu. I got this pop up So I selected Yes then I got this pop up What can I do? I am an admin on that sheet, but do I need to ask the sheet owner to try to undelete it? Will they be able to see it in…
-
How do I change the Logo in the Smartsheet Project Charter Template?
Is there a way that I can change the logo in the top right of the SS Project Charter Template? The attached picture shows the logo when I print the document to .PDF
-
Case sensitive COUNTIF
I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that define unique IDs, and COUNTIF unfortunately, is case insensitive, so it is marking…
-
User Management - Profile Pictures
Some people in my contact list have a circle icon in front of their name showing their photo. Others, "John Smith" for example show only their initials "JS" in the circle icon. When I go to User Management and edit profile for a user, I can update all their into, however I cannot find an option to upload a photo. So for…
-
How do you limit a recurring 2-day dependent task to never start on a Friday
I have a series of recurring tasks that can start on any day of the week, but the 3rd task in the series is two consecutive days and can't start on a Friday. How do I set this up?
-
Automated Workflows - Notifications not sending on Teams nor Email
Good morning everyone and happy Monday, I have been trying to sent automated notifications for my smart sheet but I can't seem to get it right. The smart sheet is shared in a public workspace and everyone in that workspace has permission to view/edit the cells. When the conditions of the workflows are met however... I…
